Handle stored procedure timeout from ASP

[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/PrintSear...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?

[Curt_C [MVP]]

I dont know an answer for your specific question but here is a side note.
If the request is going to exceed the standard timeout settings you will
want to rethink your process. In otherwords if the process takes that long
dont use it in a request system.

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Gary Homewood" <Gary Ho******@discussions.microsoft.com> wrote in message
news:F6**********************************@microsof t.com...

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/PrintSear...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?

[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.
"Curt_C [MVP]" wrote:

I dont know an answer for your specific question but here is a side note.
If the request is going to exceed the standard timeout settings you will
want to rethink your process. In otherwords if the process takes that long
dont use it in a request system.

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Gary Homewood" <Gary Ho******@discussions.microsoft.com> wrote in message
news:F6**********************************@microsof t.com...

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/PrintSear...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?