ODBC error code 126 Setting up a System DSN

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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@xxxxxxxxxxxx


.



Relevant Pages

  • Linked Server MS SQL 2000 and Pervasive 7.82
    ... I followed the setup from a previous thread on my setup between MS SQL ... --@Server is the name of the new linked server ... --@datasrc is the name of a local ODBC DSN ...
    (comp.databases.btrieve)
  • Re: how do i setup odbc on multiple profiles
    ... System DSN will work for all users on the system that it is defined on, ... >>I have several client-side computers, with several users, all accessing ... Is there a way to setup the ODBC so that that ...
    (microsoft.public.data.odbc)
  • Re: How to do a mail merge in VBA
    ... I'm using Word 2000 and MS SQL Server 2000. ... I have already setup a System DSN in ODBC. ...
    (microsoft.public.word.mailmerge.fields)
  • Linked server for ODBC data source
    ... I have an Alpha box running open VMS which has an ODBC client from easysoft ... set up as a system dsn in ODBC data sources. ... How can I set this up as a linked server in SQL 2k? ... "Microsoft OLE DB Provider for ODBC Drivers" with the data source as ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Triggers and VFP Table Connection
    ... Here's how to setup a linked server to a VFP database (and can then access ... @srvproduct = 'Microsoft OLE DB Provider for Visual FoxPro', ... > Provider Name: MS OLE DB Provider for ODBC Drivers ...
    (microsoft.public.sqlserver.server)