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.......

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

--

HTH

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


"ibeetb" wrote in message
...
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.......

"ibeetb" wrote ...

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.

--