-
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