ODBC Error Code 126

  • wyatt-652529

    SSC-Addicted

    Points: 476

    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.anderson@nwmhp.nhs.uk

  • sqlagentman

    SSCarpal Tunnel

    Points: 4373

    SQL Server (and IIS too) require System DSN. A Technet search will confirm this.

    Create the System DSN on the SQL server and it should work though I have no familiarity with Domino.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • wyatt-652529

    SSC-Addicted

    Points: 476

    Thanks for that. The problem there is that I cannot create the system dsn. I get the error:

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

    so had to set it up as a file DSN.

    Most of the bumph for this error says to check the registry is pointing to the same place the files are stored and this it does, so I don't know where to go from there. I installed teh latest MDAC but nothing changed.

    Can I not set up a Linked Server to a file dsn?

    The file DSN was setup OK. I know this because I can use it as a connection in DTS and successfully import various tables (although it does not work with the import wizard).

    I set the linked server up to the file dsn but I keep getting errors:

    '7399 Invalid Connection String attribute]

    (not sure what I was supposed to enter in the 'Product String' dialog box) Datasource name not found and no default driver specified]....'

    Any help much appreciated. wyatt.anderson@nwmhp.nhs.uk

  • sqlagentman

    SSCarpal Tunnel

    Points: 4373

    DTS can use a User, System, or File DSN. Linked Server specifically wants a System DSN.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • Stéphane Vanrechem

    SSC Journeyman

    Points: 79

    Hi,

    I've got the error message :

    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'

    When I try to create a DSN on my machine. I'm sorry but I didn't understand how this issue was solved. Can you precise ?

    Please

    Thank you

  • Carl Federl

    One Orange Chip

    Points: 25384

    An internet search found the below at http://www.expertsforge.com/Applications/Tutorial-133.asp

    Reason for the Error:

    NotesSQL expects to find Notes.ini in the \Lotus\Notes directory. If the file is not in this directory, the driver may crash when you use the ODBC Data Source Administrator to create a DSN, or the NotesSQL Authentication List Manager may report that it is unable to find a valid version of Notes.

    Solution:

    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:otesotes.ini then,

    Step 1:

    Right Click "My Computer" and Go to "Advanced" tab and click the "Environment Variables" button

    Step 2:

    Select the "Path" variable under "System Variables" in the "Environment Variables" window and click "Edit"

    Step 3:

    Add/Append ";d:otes" in the "variable value" text box (dont forget the ";" semicolon, ignore if ";" is already present)

    Step 4:

    Logoff/Restart the system

    Similarly replace the above path to the actual path where your notes.ini is present

    SQL = Scarcely Qualifies as a Language

  • wyatt-652529

    SSC-Addicted

    Points: 476

    I am not at the machine where i had this problem now and can't get back there for a while, but does anyone know if this resolved the problem? I am sceptical because the Lotus client was installed on the server in question (this is part of the NotesSQL install process) and I accepted all the defaults. Surely the Lotus setup would have used the standard directory as specified above.....?)

    Please let me know if this was fixed buy anyone else who had the same problem - and did you manage to setup a linked server?

    Thanks again.

    Wyatt

  • rock on dude

    Ten Centuries

    Points: 1236

    Yes, Carl Federl's post did the trick!

    Thanks alot.

    /Anonymous

  • roger.penny

    SSC Enthusiast

    Points: 110

    Hi there folks - I am getting this same error, but unfortunately Carl's explanation has not fixed it.

    I have installed Lotus Client 6.5 onto my sql server.

    I have also installed NotesSQL 8.0

    I have configured the Lotus client for my 'test' account

    I have ran and configured the NotesSQL Authentication List Manager - and created a Notes.ini in c:\windows with my test user details.

    When Launching the Microsoft ODBC Administrator tool, I get the error as listed above (code 126.) This is indicative of it not being able to find the notes.ini file - which is definately in c:\windows (and this is definately in my path settings.

    I'm stumped - any ideas? All help is much appreciated.

  • tvass

    SSC Enthusiast

    Points: 103

    .penny...

    You installed Notes into c:\windows ?

    I'd reckon you can't just move the notes.ini to a directory that is a value in the Path Environment Variable...

    I'm trying to figure out why you would try to do such a thing in the first place without trying to actually add your Lotus Notes directory to the PATH Variable...

    This did the trick for me... The solution is solid

  • Dhans

    Ten Centuries

    Points: 1195

    My Server is Win 2003 & SQL 2005. I got a same error code 126.

    Carl Federl's Post helped me for Configuring System DSN for Lotus Notes SQL Driver.

    Thanks to Carl.

  • johnpfjefferies

    SSC Rookie

    Points: 45

    Carl Federl (4/15/2008)


    An internet search found the below at http://www.expertsforge.com/Applications/Tutorial-133.asp

    Reason for the Error:

    NotesSQL expects to find Notes.ini in the \Lotus\Notes directory. If the file is not in this directory, the driver may crash when you use the ODBC Data Source Administrator to create a DSN, or the NotesSQL Authentication List Manager may report that it is unable to find a valid version of Notes.

    Solution:

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

    I found that this solution wasn't quite enough. I installed NotesSQL within "C:\Program Files\Lotus\NotesSQL" which is not the default. I had to add this directory to the system path before I was allowed to create a system DSN via the Windows ODBC Data Source Manager. A system restart did not seem to be required for this.

    John

  • jpalazzi 41160

    SSC Enthusiast

    Points: 186

    I am having this issue now. I have tried everything that has been posted but still having an issue.

    My notes.ini file is in C:\Lotus\Notes and my NotesSQL is in the default folder C:\NotesSQL

    I would assume I dont need to add any variable, but I am still getting the Error Code.

    Any other ideas?

  • jpalazzi 41160

    SSC Enthusiast

    Points: 186

    Also I noticed all my notes databases are on a server...should I enter that path some where?

  • indraroop.c

    SSC Journeyman

    Points: 79

    Hi,

    I do not have Ora 92 installed in my PC, hence I am not being able to solve the Error Code 126 issue.

    Please help and tell me is there any other way of solving this issue?

    I have oracle 10.2.0 installed in my system.

    Regards,

    Indra

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply