Timeout expired

Expand Post »

Hi

I often get this error on some of my asp pages

Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

what should be done to resolve it?
is there any way to trace the error and show a custom message to the users instead of the above message

Similar Threads

Timeout Expired in VB.NET
Time Expired, pool is full in ASP.NET
How to resolve timeout expired in Crystal Report. in Visual Basic 4 / 5 / 6
Timeout expired... Error detected by Database DLL in Visual Basic 4 / 5 / 6
Timeout error in ASP.NET

dips255

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

36 posts
since Jun 2008

Permalink

Jan 25th, 2009

Re: Timeout expired

The quick solution is to refresh the page again. You will need to upgrade MDAC (Microsoft Data Access Controls) to the latest version.
http://www.microsoft.com/downloads/d...7-185d0506396c

Also try to refer to your SQL server with IP address instead of instance name or server name.

Another solution is to increase the timeout value in ASP script.

asp Syntax (Toggle Plain Text)
<% 
    Server.ScriptTimeout = 180 
%>
<% 
    Server.ScriptTimeout = 180 
%>

msaqib

Reputation Points: 9

Solved Threads: 1

Junior Poster in Training

Offline

91 posts
since Sep 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Building asp form

Next Thread in ASP Forum Timeline: Redirect problem

DaniWeb Message

Cancel Changes

User Name
Password