Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

ODBC Error Code 126 Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2008 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 19, 2008 5:53 AM
Points: 4, Visits: 6
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
Post #478479
Posted Wednesday, April 2, 2008 8:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
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 MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford
Post #478576
Posted Wednesday, April 2, 2008 11:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 19, 2008 5:53 AM
Points: 4, Visits: 6
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
Post #478715
Posted Wednesday, April 2, 2008 11:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
DTS can use a User, System, or File DSN. Linked Server specifically wants a System DSN.

- Tim Ford, SQL Server MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford
Post #478730
Posted Tuesday, April 15, 2008 10:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2008 10:11 AM
Points: 1, Visits: 2
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
Post #485145
Posted Tuesday, April 15, 2008 10:24 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 2,281, Visits: 4,241
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
Post #485151
Posted Saturday, April 19, 2008 6:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 19, 2008 5:53 AM
Points: 4, Visits: 6
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
Post #487578
Posted Wednesday, May 21, 2008 1:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 8:06 AM
Points: 218, Visits: 10,576
Yes, Carl Federl's post did the trick!

Thanks alot.

/Anonymous
Post #504238
Posted Wednesday, June 11, 2008 3:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 29, 2009 6:27 AM
Points: 2, Visits: 8
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.
Post #515025
Posted Thursday, June 18, 2009 3:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 18, 2009 3:46 AM
Points: 1, Visits: 0
.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
Post #737338
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse