Handle stored procedure timeout from ASP

Discussion in 'ASP General' started by Gary Homewood, May 3, 2005.

  1. 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?
     
    Gary Homewood, May 3, 2005
    #1
    1. Advertising

  2. 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 > wrote in message
    > news:...
    > >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?

    >
    >
    >
     
    Gary Homewood, May 4, 2005
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Um9iIEM=?=
    Replies:
    0
    Views:
    576
    =?Utf-8?B?Um9iIEM=?=
    Apr 16, 2005
  2. Sam
    Replies:
    6
    Views:
    9,303
    =?Utf-8?B?U2FuZHk=?=
    May 11, 2005
  3. Peri
    Replies:
    1
    Views:
    410
    Patrick Olurotimi Ige
    Jun 13, 2005
  4. Mike P
    Replies:
    0
    Views:
    3,334
    Mike P
    Jun 19, 2006
  5. Mark Probert

    Timeout::timeout and Socket timeout

    Mark Probert, Oct 6, 2004, in forum: Ruby
    Replies:
    1
    Views:
    1,310
    Brian Candler
    Oct 6, 2004
Loading...

Share This Page