ado connection time out

howl · Post by **howl** » Tue Sep 16, 2008 2:09 pm

Using v9.1.03

I sometimes get a time out exception when opening an ado connection in the VB section of a script. I would like to either increase the connection time out or put in exception handling. Can you guide me or point me to to documentation on either option?

Thanks

Post by **Marcus Tettmar** » Tue Sep 16, 2008 2:29 pm

As you haven't provided any code I will have to guess that you are using ADODB.Connection. In which case you can set the timeout something like this:

Set conn = CreateObject("ADODB.Connection")
conn.ConnectionTimeout = 120
etc

Did you know version 10 includes native DB functions?