Linked server for ODBC data source

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.Did you install the ODBC client on the SQL Server box?
You can use a DSN but you need to create the DSN on the
server. You don't need to use a DSN though - you can also
provide the information used by the DSN in the provider
string and data source parameters of sp_addlinkedserver.
In terms of the 7399 error, that's somewhat of a generic
error. Try turning on trace flag 7300 or use SQL Profiler
to capture the OLEDB Errors event. This should give you to
get more information about the error.
-Sue
On Mon, 7 Jun 2004 12:12:03 +0100, "CCA Dave"
<david@.notreally.co.uk> wrote:

>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 curren
t
>credentials.
>sql