NotesSQL 3.02j ODBC error 126 when adding DSN

hcl-bot · October 19, 2006, 11:58am

I’ve just installed the ODBC driver. Install looked as if it went smoothly.

When trying to add a DSN via the MS ODBC Data Source Administrator I get the following errors:

“The setup routines for the Lotus NotesSQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126.”

"Driver’s ConfigDSN, Config Driver, or ConfigTranslator failed

Could not load the setup or translator library"

I checked and the PATH envrionment variable didn’t have a reference to C:\Lotus\Notes or C:\NotesSQL as it looks like it should. I added them but still no success. My registry entries look okay too.

Is anyone else having this problem?

hcl-bot · October 1, 2013, 11:33am

Subject: NotesSQL 3.02j ODBC error 126 when adding DSN // another cause …

When trying to create a new data source if you get’The setup routines for the Lotus Notes SQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126’

one thing to check is that you didn’t put a space in the Path env variable before the path to your notes.ini file, so …

“c:\utilities;C:\Program Files\lotus\notes; C:\NotesSQL” = GOOD …

even if there is a space before the c:\NotesSQL.

However

“c:\utilities; C:\Program Files\lotus\notes; C:\NotesSQL” = BAD = … error code 126 (space after ‘utilities;’)

hth

hcl-bot · October 19, 2006, 12:47pm

Subject: NotesSQL 3.02j ODBC error 126 when adding DSN

I fixed it - I added both keys instead of trying one at a time to the Path environment variable and it worked fine.

hcl-bot · October 18, 2007, 8:46am

Subject: RE: NotesSQL 3.02j ODBC error 126 when adding DSN

What do you mean both keys?? I am having the same problem and don’t understand your fix. Thanks for your help

hcl-bot · November 15, 2007, 8:46am

Subject: RE: NotesSQL 3.02j ODBC error 126 when adding DSN

I believe both ‘keys’ refers to adding both the Notes and NotesSQL install directories to the Path variables.

hcl-bot · December 18, 2008, 6:02pm

Subject: RE: NotesSQL 3.02j ODBC error 126 when adding DSN

Where are the path variables? where can I update / add them?I was using the previous version of this NOTES SQL but with this one I have this error.

your help is much appreciated.

hcl-bot · January 30, 2009, 3:03am

Subject: RE: NotesSQL 3.02j ODBC error 126 when adding DSN

Hi,here is how you can do it, it fixed my problem as well…

http://vlaurie.com/computers2/Articles/environment.htm#editing

hcl-bot · February 20, 2014, 2:00pm

Subject: NotesSQL 3.02j ODBC error 126 when adding DSN

@Sheila: You need to add path of notes.ini to your PATH variable too as written in this article http://hintdesk.com/c-lotus-notessql-driver-install-configure-and-connect-to-server-through-odbc/

hcl-bot · May 21, 2009, 4:25am

Subject: NotesSQL 3.02j ODBC error 126 when adding DSN

add to PATH variable

For single user Notes installation

path to NotesSQL (C:\NotesSQL)
path to notes.ini (C:\Documents and Settings\All Users\Application Data\Lotus\Notes\Data)

For multi user Notes installation

path to NotesSQL (C:\NotesSQL)
path to notes.ini (C:\Documents and Settings\All Users\Application Data\Lotus\Notes\Data)
path to Lotus Notes itself (C:\Program Files\IBM\Lotus\Notes)

------- this is PATH variable for my system-----------------

example: Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;c:\Program Files\Microsoft SQL Server\90\Tools\binn;C:\Documents and Settings\All Users\Application Data\Lotus\Notes\Data;C:\NotesSQL;C:\Program Files\IBM\Lotus\Notes\

hcl-bot · May 21, 2009, 4:32am

Subject: RE: NotesSQL 3.02j ODBC error 126 when adding DSN

Sorry

path to notes.ini for single user notes installation is the same as to nlnotes.exe. So you should add ";C:\NotesSQL;C:\Program Files\IBM\Lotus\Notes" to path variable

hcl-bot · August 10, 2009, 6:04am

Subject: NotesSQL 8/8.5 ODBC error 126 when adding DSN

My experience is that I couldn’t define a DSN until I installed NotesSQL into a simply named folder. I.e. when I installed it into C:\Lotus\Notes SQL 8.5\ it didn’t work. But on uninstalling and reinstalling into C:\Lotus\NotesSQL\ it worked. (and having added it to the Path env var).

Hope that helps someone.

hcl-bot · April 18, 2011, 3:18pm

Subject: RE: NotesSQL 8/8.5 ODBC error 126 when adding DSN

I am receiving this error with NotesSQL installed on a Windows 7 machine. Everything seems to be installed correctly. Has anyone else had this issue on Windows 7 before?

Thanks.