Got this error while executing a stored proc. through an ODBC connection:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver] Timeout expired
The stored proc. runs fine on isql ( dblib connection ). A search on
technet and SQLbook online does not yield anything on the 80040e31 error.
Tried to increase the remote timeout on SQL server, and edit WinNT registry
key for ODBC timeout but did not solve the problem.
Is there any special settings for ODBC on NT, or any configurations I can
set in SQLServer?
Any help is much appreciated.