RSS Forums RSS

Timeout expired

Reply
Posts: 23
Reputation: dips255 is an unknown quantity at this point 
Solved Threads: 0
dips255 dips255 is offline Offline
Newbie Poster

Timeout expired

  #1  
Jan 6th, 2009
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
AddThis Social Bookmark Button
Reply With Quote  
Posts: 84
Reputation: msaqib is an unknown quantity at this point 
Solved Threads: 1
msaqib msaqib is offline Offline
Junior Poster in Training

Re: Timeout expired

  #2  
Jan 25th, 2009
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.

  1. <%
  2. Server.ScriptTimeout = 180
  3. %>
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Views: 1305 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 10:48 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC