RichardHayes
Programmer
When calling a stored procedure that takes some time to run from within an Access module, I get the following error (by cycling through the DBEngine.Errors collection):
"7312 (01000: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Timeout expired])"
In order to avoid timeouts, I include the following line when creating the connection to the SQL Server via a DSN:
gdb.QueryTimeout = 0
Where is the timeout occurring? Any ideas how I can avoid this?
"7312 (01000: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Timeout expired])"
In order to avoid timeouts, I include the following line when creating the connection to the SQL Server via a DSN:
gdb.QueryTimeout = 0
Where is the timeout occurring? Any ideas how I can avoid this?