ASP DSN Connection Timeout (SQL Server 2K)
Posted on 2004-08-18
I am having a problem with an ASP page timing out. I am using this DSN connection to get data from a SQL 2K server:
MM_PCWW_STRING = "dsn=***;uid=***;pwd=***;ConnectionTimeout=300;CommandTimeout=600;"
I get the following error when I use this code:
<% Response.ContentType = "application/vnd.ms-excel" %>
to export recordset the recordset into excel, the error is:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver]Timeout expired
If I return less then 500 records the export usually works fine, more then 500 it timesout. Also I use the same recordsets on another page to display them online and it works everytime (I have displayed up to 1000 records at a time online wihtout issue), never times out.
Anyone have any suggestion? I developed the pages using Dremanweaver MX, any thoughts would be appreciated? It seems to have to do with the commandtimeout property, but it times out within 30 seconds ecerytime exporting more then 500 records, did I set the property right in the DSN string? (If I export less then 500 redords the XLS page is about 250K in size)