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/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.