ODBC Hanging Domino Server

HCL Domino Domino Forum
1

Does anybody know if a Domino 6 server will hang if an ODBC Connection is unable to ping the server on which the SQL database resides. This used to be an issue with Domino R5, I am not sure if teh problem has been fixed in R6.

Thanks

2

Subject: ODBC Hanging Domino Server

We had that issue (both in R5 and R6) until the following code was added:

If Not (con.IsConnected) Then

Print "Connection could not be established, terminating agent"

Exit Sub

End If

3

Subject: ODBC Hanging Domino Server

I had a problem with NotesSQL ODBC driver 3.02 which connected from SQL to Notes 6.0. When a connection was established, the notes server hung. (In this case the database is a R5 database.)

When I used NotesSQL 3.01 the problem did not occur.

I recommend u do not use NotesSQL 3.02, instead Notessql 3.01.