Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL 7 - Windows 2000 - IIS 5 - ODBC Timeout Expired

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-15 : 08:06:20
Craig writes "Hi,

I have a stored procedure that executes fine when it is run in Query Analyzer. It takes an average of 53 seconds to execute.

My problem surfaces when I try to call and execute the stored procedure from asp code.

Each time I get a ODBC Timeout Expired error.

The default timeout for sql stored procedures is set at 10 minutes, as is the asp script timeout value.

Any help would be greatly appreciated.

Regards

Craig"
   

- Advertisement -