ODBC error code 126 Setting up a System DSN

[Wyatt]

Can anyone help?

I am trying to setup a system DSN (on SQL2K SP4) to setup a linked server to
a Domino backend.

I am trying to setup the SQLNotes ODBC as a System DSN but I get the error
message:

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

I can set this up as a file DSN no problem but as far as I can tell, you
cannot setup a linked server to a File DSN.

If anyone can tell me anything useful, I will be grateful.

Wyatt.a...@nwmhp.nhs.uk

[Ivy Alice Burns]

Hi,
I have the same problem as your, did you find a solution ?

Best regards,
Ivy

url:http://www.ureader.com/msg/1153849.aspx

[Senthil Kumar]

If you must place Notes.ini in a directory other than \Lotus\Notes, add the
directory to your PATH environment variable.

Example:
If you place the notes.ini in d:\notes\notes.ini then,
Right Click "My Computer" and Go to "Properties" and then "Advanced" tab
and click the "Environment Variables" button
Select the "Path" variable under "System Variables" in the "Environment
Variables" window and click "Edit"
Add/Append ";d:\notes\" in the "variable value" text box (dont forget the
";" semicolon, ignore if ";" is already present)
Restart the system

url:http://www.ureader.com/msg/1153849.aspx