TimeOut Expired

[sherly]

Hello, I wrote some scripts using ASP to update the SQL Server 2000.
I have include the following codes at my ASP :
Response.Buffer = "True"
Response.Flush
Server.ScriptTimeOut =3600

But I keep getting this message displayed before the update query is completed

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

I have set the query time out property in my SQL Server 2000 to 3600 sec.
The script keep timing out at a very short time.
What should I do?

 

[ebarratt]

Server.ScriptTimeOut =3600 I believe that this is in milliseconds which means that 3600 is 36 seconds. Errol Barratt
856-697-1593
New Jersey

 

[ebarratt]

I looked it up you are correct the 3600 is 3600 seconds in the server object. Although you probably will never need that much. Sorry could not be of assistance. Errol Barratt
856-697-1593
New Jersey