Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Timeout

Author  Topic 

Scott
Posting Yak Master

145 Posts

Posted - 2001-11-05 : 06:31:58
I am running a search and update loop in an asp page. After about 350 rows the database seemingly stops responding and I get the following error:

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

[Microsoft][ODBC SQL Server Driver]Timeout expired

I have tried setting the CommandTimeout property but all this does is the same number of records get processed then the asp goes into a wait state until the timeout is up then gives me the same error.

   

- Advertisement -