Connection timeout

[turfbult]

Hello,

I have a DB which is lying on a remote machine at my webhost. I need to do a pretty big change on all the records on some of the tables and have written a VB program which connects to this machine and then does the update.

My problem is that I get a timeout error after a few minutes and would like to know how I can increase the timeout time.

Thanks,
T

By the way, it is a sql server db

yourconnectionobject.ConnectionTimeout = numberof seconds:

set adoCon = New ADODB.Connection

adoCon.ConnectionTimeout = 600


Timeout is set to 10 minutes