Connection timeout

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