Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Fairfax, VA
    Posts
    2

    Unanswered: Calling Stored Procedure from ASP-Problem

    I am having a problem to execute a stored procedure from ASP.

    I have created several stored procedure(SP) and everything works fine from ASP except 3 of my StoredProcedures.

    This SP has an INSERT Statement where the SELECT query has couple of joins to master tables. When I run this StoredProcedure (SP) in the server using Queryanalyser, it takes nearly 30 seconds to complete, and it runs without any problems.

    When I execute this SP from ASP like any other SPs, procedure starts and it doesnot complete the INSERT statement. ASP dosnot raise any errors, i checked for error messages and no errors. I don't know whats going on..?
    I also observerd that, SPs which was failing was taking more than 30 seconds to complete when I run from the Server, and all other SPs which was running ok was taking less than 20 seconds. So is there any settings in the ADODB connection? or any other settings in ASP?

    Please help

    -Ish

  2. #2
    Join Date
    Nov 2002
    Posts
    9

    Re: Calling Stored Procedure from ASP-Problem

    By default ASP times out after 30 seconds. Talk to your webmaster or network admin about increasing the timeout period. Better yet, if you can, optimize the stored procedure to run faster.

    Richard

    Originally posted by Ishwara Marakaj
    I am having a problem to execute a stored procedure from ASP.

    I have created several stored procedure(SP) and everything works fine from ASP except 3 of my StoredProcedures.

    This SP has an INSERT Statement where the SELECT query has couple of joins to master tables. When I run this StoredProcedure (SP) in the server using Queryanalyser, it takes nearly 30 seconds to complete, and it runs without any problems.

    When I execute this SP from ASP like any other SPs, procedure starts and it doesnot complete the INSERT statement. ASP dosnot raise any errors, i checked for error messages and no errors. I don't know whats going on..?
    I also observerd that, SPs which was failing was taking more than 30 seconds to complete when I run from the Server, and all other SPs which was running ok was taking less than 20 seconds. So is there any settings in the ADODB connection? or any other settings in ASP?

    Please help

    -Ish

  3. #3
    Join Date
    Apr 2003
    Location
    Fairfax, VA
    Posts
    2

    Re: Calling Stored Procedure from ASP-Problem

    Originally posted by ambroser
    By default ASP times out after 30 seconds. Talk to your webmaster or network admin about increasing the timeout period. Better yet, if you can, optimize the stored procedure to run faster.

    Richard
    ambroser,

    Thanks for your reply. Are you talking about script timeout or session timeout? I already increased this timeout values in the server, but no luck.
    When these stored procedures fails they don't raise any erros, they just don't execute, ASP continues and processes the next stored procedure. Basically i don't get any timeout errors.

    Thanks
    Ish

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •