Wednesday, July 20, 2011

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

I tried to create a system DSN for ODBC connection to the Lotus Notes Database and I got the following error:

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

Solution
Just append the Lotus Installation Path to the Path environment variable and try setting up the DSN again and it will work.

4 comments:

WorkManProfile said...

Thanks, but can you be more specific? Where exactly do i add the varaible to? There are a lot of environment variables that can be added; which filename should i edit? None of them refers specifically to NotesSQL- does this mean that i have to create a new variable? Sorry for all these questions but there is a lack of any detail anywhere on the web that i have searched, on this error.Thanks again

WorkManProfile said...

Thanks, but can you give more detail? I need to edit which environment variable exactly? Or do I create one and does it have to have a specific name? etc etc. Sorry for all these questions but there is precious little information on how to resolve this on the web , that i can find

Anupama Natarajan said...

Hi

You need to edit the PATH environment variable. The name is PATH

Anu

Unknown said...

I think we have to also add path to notes.ini and notes sql to environment variable.

I found this post is very helpful when I tried to configure the installation

http://hintdesk.com/c-lotus-notessql-driver-install-configure-and-connect-to-server-through-odbc/

Post a Comment