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 Timeout Error on Stored Procedure

Author  Topic  bamunro Starting Member 3 Posts Posted - 2001-05-08 : 08:58:18 Hello all - I'm executing a fairly large stored procedure from an ASP page. This page first runs a DTS to upload and excel file and then the SP runs about 10-12 update and delete queries. When I run this I get the following error: Microsoft SQL Server Driver Timeout Expired I've tried bumping up my connection and script timeouts but that doesn't seem to help. Should I be executing this in some special way? Are there other timeout variables that I should be setting? Is there something in my db connection that I should have set? Please help - this has been driving me nuts for a week now!! Any help is much appreciated.