McAfee and NotesODBC
I’ve been stuck with this for a couple of days.
Latest McAfee antivirus seems to install an e-mail scanner on Lotus Notes, which causes errors with the NotesODBC driver (tested up to 3.0.2g).
More precisely, when trying to open a ODBC connection, it displays a message window stating that a file can’t be found. The connection is then blocked (and the nsql32.exe process is left running) until the user clicks “OK“.
In my case, it was a server-side (headless) app, so no one could ever click that button.
The solution is to disable virus scanning. I’ve done so by removing the following two lines on notes.ini:
Now it’s working… at last.