I have been able to access a Notes database using ODBC. However, errors via ODBC are not able to be trapped. Errors go to an ODBC window. Do you have a Native database access module for Notes? If not do you know where I can obtain one?

Thanks,

David.

Sorry, there is not native driver for Notes. May be it is still possible to avoid these errors or ODBC window. What kind of errors are you getting?
What document types are you going to access in Notes? What kind of task are you trying to automate?

: I have been able to access a Notes database using ODBC. However, errors via
: ODBC are not able to be trapped. Errors go to an ODBC window. Do you have
: a Native database access module for Notes? If not do you know where I can
: obtain one?

: Thanks,

: David.

: Sorry, there is not native driver for Notes. May be it is still possible to
: avoid these errors or ODBC window. What kind of errors are you getting?
: What document types are you going to access in Notes? What kind of task are
: you trying to automate?
I am doing an DatabaseConnect

DatabaseRetrieve

DatabaseDisconnect.
This is to verify that Note is functioning. When Notes is down, a window opens up with an SQL error. I believe it is an internal SQLSTATE S1000. However, I have yet to verify this. The fist window shows "[lotus][odbc lotus notus notes]server not responding" and wants and OK. The second window is the ODBBC Lotus Notes Connection window with an OK, Cancel and Options button. If OK is choosen, we loop through the windows again, if cancel is chosen we return to 24X7.

David.

If the connection is setup correctly, the ODBC Connect dialog, should not appear, even if the server is down or not responding. Please ensure that you have all nessesary parameters specified in both places the connection in ODBC Connection Setup dialog and in the 24x7 Database Profile.

Also, make sure you have the laest NotesSQL driver
One location for this driver is the following URL:
ftp://ftp.lotus.com/pub/lotusweb/product/devtools/notessql/Nsqlw32.exe

: I am doing an DatabaseConnect

: DatabaseRetrieve

: DatabaseDisconnect.
: This is to verify that Note is functioning. When Notes is down, a window
: opens up with an SQL error. I believe it is an internal SQLSTATE S1000.
: However, I have yet to verify this. The fist window shows
: "[lotus][odbc lotus notus notes]server not responding" and wants
: and OK. The second window is the ODBBC Lotus Notes Connection window with
: an OK, Cancel and Options button. If OK is choosen, we loop through the
: windows again, if cancel is chosen we return to 24X7.

: David.