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

BUT
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.ConnectionTimeout=300
            adocon.CommandTimeout=300
            adocon.open myConnection

            dim rs
            set rs=server.CreateObject("ADODB.Recordset")
            rs.CursorLocation=adUseClient
            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 
'Try....
code that can fail here.........

If Err.Number<>0 Then
'Catch...
   Response.Write("an error has occurred. Description: " & Err.Description)
End If
commented: Thanks. Yest thats the only way. +0
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.