Hello, I am getting a error while trying to execute a SQL Server query via ADO. The Error number is -2147217871 (80040e31) 'Timeout Expired' Is there any way that I can set a timeout value so the program waits longer? Thank you.
Joshua Wolfe
Sat, 20 Dec 2003 07:06:07 GMT
Parthasarathy Mandaya #2 / 4
Timeout Expired Error?
You have to set the timeout in SQL Server configuration properties.
Certified VB6, SQL 7 and ASP developer Home Page: http://partha.tripod.com
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Sat, 20 Dec 2003 07:38:24 GMT
Joshua Wolf #3 / 4
Timeout Expired Error?
How do I do that?
Joshua Wolfe
Quote:
> You have to set the timeout in SQL Server configuration properties.
> Certified VB6, SQL 7 and ASP developer > Home Page: http://partha.tripod.com
> *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it!
Sat, 20 Dec 2003 08:26:51 GMT
Juli #4 / 4
Timeout Expired Error?
You can set the timeout in the ADO Connection object. The property is something like .CommandTimeout. The default timeout is 30 seconds.
Quote:
> Hello, > I am getting a error while trying to execute a SQL Server query via ADO. > The Error number is -2147217871 (80040e31) 'Timeout Expired' > Is there any way that I can set a timeout value so the program waits longer? > Thank you.
Timeout Expired Error?