I keep getting this error after install NotesSQL v8.0, anybody have any ideas as to what is wrong?
The setup routines for the Lotus NotesSQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126.
Could not load the setup or translator library
Thanks for any help
Subject: Solution Found
I encountered same error. We need to add path to notes.ini, lotus notes client and lotus notes sql in environment variable. This guide helps me got through the setup progress of NoteSQL http://hintdesk.com/c-lotus-notessql-driver-install-configure-and-connect-to-server-through-odbc/
Subject: NotesSQL v8.0 Help
I got almost the same error - however I get error code 127. I’m running Windows Vista
I ripped this from a draft technote - it may help in your case, even though it didn’t in mine.
The error message, “Set up routines for Lotus Notes SQL driver *.nsf ODBC driver could not be loaded due to system error code 126.” indicates that the NotesSQL driver is either looking for one of its components or the Notes or Domino program directories.
Requirements:
1.) The Notes or Domino program directory where the notes.ini is located must be in the path. Multiple notes.ini’s in the path may cause problems if an invalid one is found first.
[Lotus NotesSQL Driver (*.nsf) (32 bit)]
Driver=C:\NotesSQL\nsql32.dll
Setup=C:\NotesSQL\nsqlc32.dll
32Bit=1
The directories may change depending on your installation. If there are multiple entries in this ini they may cause problems.
There are matching entries in the registry:
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Lotus NotesSQL Driver (*.nsf)]
UsageCount = 0xb
Driver = C:\NotesSQL\nsql32.dll
Setup = C:\NotesSQL\nsqlc32.dll
ConnectFunctions = YYY
FileExtns = *.nsf
FileUsage = 2
SQLLevel = 0
APILevel = 1
The best solution is to uninstall NotesSQL from the Control Panel, and the reinstall.
Subject: RE: NotesSQL v8.0 Help
I fixed the system error code 127 as well.
Basically I added my Notes program dir and c:\notessql to the start of the path environment variable. Initially I had added at the end of that, and apparently that’s not an option :-/
Maybe it’s because there is some dll conflict (similar dll name earlier in path).
But anyway - now it works…
Subject: RE: NotesSQL v8.0 Help
That worked, thanks so much for your help.
Subject: NotesSQL v8.0 Help
You need to add the NotesSQL directory (usually c:\notessql) and the directory where your notes.ini files is located (usually c:\program files\lotus\notes) to your path.