Microsoft OLE DB Provider for ODBC Drivers error '80040e31'


All replies

    Monday, September 24, 2007 9:36 PM
  • What is the solution for this error?  Our SQL server will down 4 or 5 times a day, but most of the time it works fine.  It is a kind of crazy.

    Wednesday, October 17, 2007 2:44 PM

    I got this error while trying to access my shopping basket on the website.  I'm trying to find out how to make it work.  The whole thing reads:


    Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

    [Microsoft][ODBC SQL Server Driver]Timeout expired

    D:\INETPUB\WWWROOT\BIGDOGS\SHOPPING\../functions/data_access.asp, line 39

    I'm trying to find out where I can input the error code 80040e31 on the Microsoft site to figure out how to fix it.  What's the deal? lol

    Monday, October 05, 2009 12:25 AM
  • Here's a list of OLE DB errors and their explanation -
    Check out the return codes from ICommand::Execute -

    DB_E_ABORTLIMITREACHED is returned when time-out occurs. Basically, your SQL Server did not respond within timeout specified on the command. This timeout is controlled by DBPROP_COMMANDTIMEOUT property (

    There are a few ways to solve your problem:

    1. Understand why your SQL Server doesn't respond within the time-out. Investigate what query is timing out and why. Analyze concurrency and resource locking. If you do a simple query, ensure that this table is not locked by any other transaction. Etc...
    2. Increase the time-out on the client (set this property value to 45 seconds). Don't think this will satisfy your users but still an option.
    Monday, October 05, 2009 4:53 PM