[thelist] 40 Seconds

[Rob Smith]

Hi,

 

I'm getting:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/...filepath.../MyPage.asp, line 34

Line 34 is the rs.open command on a query. This query takes longer than
40 seconds to analyze the data at hand. I've set the ASP script timeout
on the server to 180 seconds. What else can I do to lengthen the time
before a time out event occurs?


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)