Published by exdone
Posted on July 18, 2008
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Timeout expired
Microsoft OLE DB Provider for SQL Server error ‘80040e31’
As an immediate workaround, force TCP/IP lookup in your connection string and make sure you refer to the SQL Server by IP address
also run the query directly on the sql server and see if the server delays the results.
also check the log file size, if the log is too large it can cause this time out error