Command.Timeout option

[Jawahar Rajan]

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

[Ray at]

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