Handle stored procedure timeout from ASP

G

Gary Homewood

I have an ASP page calling a stored procedure. I have set the connection and
command timeouts and I have error checking so I can trap a timeout from the
stored proc (as detailed here)
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=142

This works if the stored proc just contains a "WAITFOR DELAY", but doesn't
seem to throw an error when the stored proc contains long-running sql. Anyone
have any ideas?
 
G

Gary Homewood

Thanks for the response, and I agree that it may not be the best architecture
to call a long-running stored procedure from ASP, but I'd still like to know
why I can't catch the timeout.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top