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

-IshBy 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|||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