Timeout Error

[ibeetb]

How can I override an odbc Timeout error while using ADO to open a DB? I am
trying to open a connection and it is timing out on the server.......

 

[Bob Phillips]

Surely, you need to investigate why you get a timeout and fix that?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jamie Collins]

How can I override an odbc Timeout error while using ADO to open a DB? I am
trying to open a connection and it is timing out on the server

Do you mean:

Dim lngError As Long

On Error Resume Next
Con.Open
lngError = Err.Number
On Error GoTo 0

Select Case lngError
' ...
?

You may also want to consider changing the Connection object's
ConnectionTimeout property.

Jamie.

--