Query Timeout error
This is a discussion on Query Timeout error within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi There, I sometimes get the following error when I execute a SQL 2005 stored procedure using ADO VBA ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2008, 06:12 AM
| ||||
| ||||
 Query Timeout error Hi There, I sometimes get the following error when I execute a SQL 2005 stored procedure using ADO VBA in Access 2003. -2147217871 MS ODBC SQL Server Driver Timeout Expired The ODBC Query Timeout Reg key is set to 0 and the SQL Server remote query timeout options are configured as in this article: http://support.microsoft.com/kb/314530/en-us I never get this when I execute the stored procedure in SSMS Express. Another oddity is that the query usually succeeds even when I get the error. Are there any other settings to try? TIA, Josh      |
Linear Mode
