all groups > sql server odbc > october 2003 >
You're in the

sql server odbc

group:

ODBC Timeout error


ODBC Timeout error Vincent
10/28/2003 1:56:33 AM
sql server odbc:
Need help ....

why does this error appears ?

Page Cannot be Displayed

Error Type
Microsoft OLE DB Provider for PDBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver] Timeout expired
/login/login_body.asp,line 457

Is it the system connection between the SQL server and the
Web server having problem ?

Or scripting on the application ?

ODBC Timeout error anonymous NO[at]SPAM discussions.microsoft.com
10/28/2003 9:27:52 AM
One of three things,
1. A connection timeout
2. A command timeout
3. A script timeout

At the top of your ASP page add
<%
SERVER.SCRIPTTIMEOUT = 360
%>
to solve 3

In your connection string or within your with statement
for your connection string add the following lines.

..connectiontimeout = 360
..commandtimeout=360
_________________________________________________________
WARNING:
This is only a temporary fix, it does not solve the
underlying problem which is that your connection, command
or script is taking too long.

You choices in truely fixing this are varied.
1. Check your Network (3rd Party tools)
2. Check your connections (ENT MAN)
3. Chekc you LOCKS (ENT MAN)
4. Analyze your transactions (PROFILER)
__________________________________________________________

Large networks can have a lot of overhead. If your network
is just busy all the time, then you may need to bump up
the timeout setitngs as stated above. I would not go a
long as 360, I just use this for testing to make sure that
I can connect.

Remeber these are captureable errors, and you can redirect
to an error page explaining the problem to the user
delicately.

cjones
DBA

[quoted text, click to view]
ODBC Timeout error Vincent
10/28/2003 5:41:33 PM
cjones

thanks for the info I'll try and get back to you with the
results ...

Rdgs,
Vincent
[quoted text, click to view]
AddThis Social Bookmark Button