ODBC error 80040e31

Hi Everyone,

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.
Hung Binh


hungbinhAsked:
Who is Participating?
 
Jackie071497Connect With a Mentor Commented:
See the page at :
http://www.kisco.co.kr/archives/MicroSoft9704/0143.html
Follow the 'Next in thread', you will get the solution.

0
 
soferstamCommented:
This link are not working.
Please help as.
0
 
soferstamCommented:
This link are not working.
Please help as.
0
 
EpurchaseCommented:
THE LINK IS NOT WORKING
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.