Linked server for ODBC data source

From: CCA Dave (david_at_notreally.co.uk)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 12:12:03 +0100

Hope someone can help with this:

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. I can select the data source
from Excel/Access/VB asp etc with a connection string of "dsn=dsnname"

How can I set this up as a linked server in SQL 2k ?

I have tried using enterprise manager & creating a linked server for
"Microsoft OLE DB Provider for ODBC Drivers" with the data source as
"dsnname" and the provider string as "dsn=dsnname". Is the the correct way
to use a system dsn as a linked server? If so, are there any other
parameters to set up as I can't see any tables, and get an error : 7399,
OLEDB provider 'MSDASQL' reported an error, provider did not give any
information....IDBinitialize returned 0x80004005

Is this a login or security problem? I just want the login to use my current
credentials.

Relevant Pages

  • OLE DB Provider for ODBC and Oracle
    ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC. ... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ...
    (comp.databases.ms-sqlserver)
  • Re: Linked server to as400 - for the love of god please help.
    ... > There is an ODBC DSN on the server machine. ... Creating a linked server using ... > OLE DB provider 'MSDASQL' reported an error. ... > So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • Linked Server Query Fails
    ... I am working with a linked server (using MS OLE DB Provider for ODBC Drivers) ... performing select queries from the ODBC DB and inserting the results into ...
    (microsoft.public.data.oledb)
  • Re: Linked server to as400 - for the love of god please help.
    ... You are SO tired of IBM. ... >> There is an ODBC DSN on the server machine. ... Creating a linked server ... >> So i instead create a linked server using IBM's own OLEDB provider. ...
    (microsoft.public.sqlserver.server)
  • ODBC error code 126 Setting up a System DSN
    ... I am trying to setup a system DSN to setup a linked server to ... Microsoft ODBC Administrator ...
    (microsoft.public.sqlserver.odbc)
Loading