Results 1 to 2 of 2

Thread: Connection timeout

  1. Jan 11th, 2001, 02:40 PM #1
    turfbult
    turfbult is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2000
    Posts
    343
    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
    Reply With Quote Reply With Quote
  2. Jan 11th, 2001, 05:42 PM #2
    Guest
    yourconnectionobject.ConnectionTimeout = numberof seconds:

    set adoCon = New ADODB.Connection

    adoCon.ConnectionTimeout = 600


    Timeout is set to 10 minutes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width