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
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/details.aspx?familyid=6c050fe3-c795-4b7d-b037-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.
<%
Server.ScriptTimeout = 180
%>We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.