1.11M Members

Handle SQL timeout with custom message to the user


an asp page of mine with server.ScriptTimeout=540 seconds
this page is then executing a select query from a huge database table which is properly indexed

few times there is a SQL timeout because of conditions passed in query

is there a way to handle the SQL timeout and display a user friendly message to the user to refine the search conditions.

            dim adocon
            set adocon=server.CreateObject("ADODB.Connection")
            adocon.open myConnection

            dim rs
            set rs=server.CreateObject("ADODB.Recordset")
            rs.open "my query goes here", adocon

my Server:
- Windows Server 2008
- MS SQL Server 2008 R2


As you may already know, ASP doesn't provide a try...catch block for you to trap errors.

The closest approach would be something like this...

On Error Resume Next 
code that can fail here.........

If Err.Number<>0 Then
   Response.Write("an error has occurred. Description: " & Err.Description)
End If
This article has been dead for over six months: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: