J
Joshua A. Booker
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
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