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

--