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