Notes SQL 9.0 stopped working

0
votes

I am trying to use IBM ODBC Driver for Notes/Domino 9.0 with Lotus Notes 9 to access distribution lists. I have successfully added a datasource (referencing a server) in ODBC Manager like so:

Lotus Notes ODBC setup

I have added the ...\IBM\Notes\ location to my PATH, as well as the driver's location, ...\NotesSQL\ as suggested elsewhere. However when testing the connection using ODBCTest (or other software), the following error occurs:

IBM ODBC Driver crash

I suspect this has something to do with not finding the correct notes.ini file (which is mentioned here). I see there are multiple notes.ini files on my filesystem, so I attempted to test each one. I tried appending the location of each of these files to the beginning of PATH in turn, but none of these changes fixed the issue. I also noticed none of the existing notes.ini files are in the ...\IBM\Notes folder with notes.exe where IBM suggests notes.ini lives by default.

How do I:

1) determine which is the correct notes.ini

2) get Notes SQL to recognize that notes.ini, assuming that's the underlying issue.

2
odbclotus-noteslotus-domino

2 Answers

0
votes

Check the properties of the desktop/menu shortcut that starts your Notes client. The target should look like this:

"C:\Program Files (x86)\IBM\Notes\notes.exe" "=C:\Some\Path\To\notes.ini"

That should be the correct notes.ini file for your installation.