468,140 Members | 1,626 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,140 developers. It's quick & easy.

ConnectionTimeout and CommandTimeout ignored when running ASP on Windows Server2003 with IIS 6.0

I am running ASP code that was migrated from a Windows 2000 Server to a
Windows 2003 server. For some reason the connection timeout or command
timeout are getting ignored and my query time sout after 30 seconds. My
connection times are set as follows in an include file:

Dim objDBConnection
Set objDBConnection = Server.CreateObject("ADODB.Connection")
With objDBConnection
.ConnectionString = Application("ConnString")
.ConnectionTimeout = 180
.CommandTimeout = 240
.Open
End With
Thank you,

Tim
Oct 4 '05 #1
1 3909
Tim Meagher wrote:
I am running ASP code that was migrated from a Windows 2000 Server to
a Windows 2003 server. For some reason the connection timeout or
command timeout are getting ignored and my query time sout after 30
seconds. My connection times are set as follows in an include file:

Dim objDBConnection
Set objDBConnection = Server.CreateObject("ADODB.Connection")
With objDBConnection
.ConnectionString = Application("ConnString")
.ConnectionTimeout = 180
.CommandTimeout = 240
.Open
End With


Are you sure it's your query timing out (you would be getting an ADO message
in this case), and not your script timing out (you would be getting a
vbscript message in this case)? Try setting your server.ScriptTimeout to a
larger number.

Incidently, it's a bad idea to execute long-running queries from ASP,
especially if you want your application to scale. Is there anything that can
be done to optimize the query rather than bogging down your web server?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Oct 4 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by BVM | last post: by
9 posts views Thread by Tim Cali | last post: by
2 posts views Thread by Amihai | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.