i have created a an asp page that contains
5 search boxes and 5 drop down boxes. the search boxes contain the search strings while the drop downs specifcy what field to search for that search string. i created 3 sql stored procedures. the first creates a temporary table of all records. the second deletes records from the temporary table that don’t match any of the search criteria.
the third, which is the one called from the asp page is the one that sends the search parameters to the second one. my problem is that when i run the stored procedure from the query analyzer it runs fine ~5 seconds. if i call it from an asp page it times out
i’ve increased the server.scripttimeout to over 5 minutes and it still times out. what gives? i’d appreciate any help. here’s the code that calls the stored procedure.
Set objConn = Server.CreateObject “ADODB.Connection”)
objConn.Open strConn
strQuery = “stored procedure ‘param’,’param'”
Set objRS = objConn.Execute(strQuery)