469,275 Members | 1,871 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Command.Timeout option

All,
I am using ADO to connect to a database to get some data that I then display
on my web page.
I build the entire script in ASP code the finally use response.write to get
the web page itself
When I create the connection object
set objConn = Server.Create.Object("Server.Command)
objConn.Timeout = 90

Even thought I set the time out to 90 seconds the time out occurs in 30
seconds. And this is pain as I have some large queries returning some 100K
records.
Is there any other way of increasing the timeout
Is it a Registry setting on IIS?

Thanks
Jawahar
Jul 19 '05 #1
1 2979
Perhaps you should post the majority of your relevant code. The code you
posted below has a number of syntax errors. Also post what error you're
receiving, and on what line (not the number, but point out the line).

Ray at home

"Jawahar Rajan" <jr****@nc.rr.com> wrote in message
news:Rr*********************@twister.southeast.rr. com...
All,
set objConn = Server.Create.Object("Server.Command)
objConn.Timeout = 90

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Cath B | last post: by
3 posts views Thread by rh0dium | last post: by
2 posts views Thread by mydejamail | last post: by
2 posts views Thread by John Kotuby | last post: by
2 posts views Thread by Gil_H | last post: by
3 posts views Thread by Mufasa | last post: by
7 posts views Thread by =?Utf-8?B?a19tYW4=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.