See if any of these help you: http://www.aspfaq.com/show.asp?id=2066

Most likely it's the CommandTimeout.

Shawn

> I have been trying to run a select against a SQL Server 7 database from 
an ASP page.  In Query Analyzer it takes 45 seconds to run.  From the ASP 
page I get a "Microsoft OLE DB Provider for SQL Server error '80040e31' 
Timeout expired" error message.  I have not been able find where I can 
increase the time for a script to run.  Any ideas? 

I have been trying to run a select against a SQL Server 7 database from an ASP page.  In Query Analyzer
it takes 45 seconds to run.  From the ASP page I get a "Microsoft OLE DB Provider for SQL Server error '80040e31' 
Timeout expired" error message.  I have not been able find where I can increase the time for a script to run.  Any ideas? 

Tom Achtenberg
Developer, Information Technologies
Food for the Hungry / US
(xxx) xxx-xxxx  (voice)
(xxx) xxx-xxxx  (fax)
Tom.Achtenberg@f...