Aug
18
2011

SQL 2000 – Microsoft OLE DB Provider for SQL Server error ‘80040e31’

Today after searching for possible causes of OLEDB timeout error faced by an application came across various links and lastly found a useful link 

Article states:

 I have heard many people saying that their web site is chugging along, and suddenly they get this error: 
 

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) 
[Microsoft][ODBC SQL Server Driver]Timeout expired

 
or 
 

Microsoft OLE DB Provider for SQL Server error ‘80040e31’ 
Timeout expired

 
This can often be fixed by “kicking” the server, e.g. hitting refresh on the affected ASP page eliminates the problem. But how about a longer-term fix? 
 
If you have MDAC 2.6 installed, upgrade to the latest version of MDAC from MDAC Download Page. As an immediate workaround, force TCP/IP lookup in your connection string and make sure you refer to the SQL Server by IP address, not by name. For more info see Article #2082 and Article #2126
 
The timeout can be caused by a name -> ip lookup. This is a problem with the version of DBNetLib.dll that shipped with MDAC 2.6 — see KB #300420 for more information. 
 
While a quick bandage would be to increase timeout values (see Article #2066), a better approach would be to make your queries more efficient. For many ideas, see Article #2424

 

Issue is resolved after we replaced SQL server name with ip address in connection string.

Microsoft article on it link

 

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: