Solved

ODBC error 80040e31

Posted on 1997-12-03
4
1,697 Views
Last Modified: 2010-12-13
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


0
Comment
Question by:hungbinh
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
Jackie071497 earned 100 total points
ID: 1089440
See the page at :
http://www.kisco.co.kr/archives/MicroSoft9704/0143.html
Follow the 'Next in thread', you will get the solution.

0
 
LVL 1

Expert Comment

by:soferstam
ID: 2667208
This link are not working.
Please help as.
0
 
LVL 1

Expert Comment

by:soferstam
ID: 2667241
This link are not working.
Please help as.
0
 
LVL 1

Expert Comment

by:Epurchase
ID: 24361949
THE LINK IS NOT WORKING
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question