Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ODBC Error Code 126


ODBC Error Code 126

Author
Message
wyatt-652529
wyatt-652529
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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
Timothy Ford-473880
Timothy Ford-473880
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1035 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
wyatt-652529
wyatt-652529
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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
Timothy Ford-473880
Timothy Ford-473880
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1035 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
Stéphane Vanrechem
Stéphane Vanrechem
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
Carl Federl
Carl Federl
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2338 Visits: 4349
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
wyatt-652529
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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
rock on dude
rock on dude
SSC Veteran
SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)

Group: General Forum Members
Points: 224 Visits: 10576
Yes, Carl Federl's post did the trick!

Thanks alot.

/Anonymous
roger.penny
roger.penny
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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.
tvass
tvass
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search