471,090 Members | 1,357 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

Linked server SQL to DB2

I'm having problems creating a linked server from SQL Server 2000 to
DB2.

I have an System DSN using Client Access ODBC Driver.

I am trying to create the linked server using Enterprise Manager as
below,

Linked Server: MYLINKSERVER
Provider:Microsoft OLEDB Provider for ODBC
Data Source: MYDSN
Provider String: DSN=MYDSN;UID=MYUID;PWD=MYPWD;DATABASE=MYLIB;

When I try to view the tables I receive an error message, "Data Soure
name not found and no default driver specified."

I know the DSN, UID and PWD are OK because I have been using them to
connect to DB2 using DTS and ADO code.

Does anyone have any suggestions?

(Maybe there is problem with the Driver. I am trying to get hold of
"Microsoft ODBC Driver for DB2".)

Thanks,

David McDonough
Jul 20 '05 #1
1 5274
David McDonough (da*************@hotmail.com) writes:
I'm having problems creating a linked server from SQL Server 2000 to
DB2.

I have an System DSN using Client Access ODBC Driver.

I am trying to create the linked server using Enterprise Manager as
below,

Linked Server: MYLINKSERVER
Provider:Microsoft OLEDB Provider for ODBC
Data Source: MYDSN
Provider String: DSN=MYDSN;UID=MYUID;PWD=MYPWD;DATABASE=MYLIB;

When I try to view the tables I receive an error message, "Data Soure
name not found and no default driver specified."


I would guess that for one reason or another, SQL Server cannot
find the DSN. If SQL Server runs on a different machine than you
are working on the answer is trivial. But even if it the same, I could
guess that there are access problems.

I would try to set up the connection without a DSN.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by David Gray | last post: by
4 posts views Thread by pheonix1t | last post: by
1 post views Thread by tim.pascoe | last post: by
11 posts views Thread by bofh1234 | last post: by
6 posts views Thread by Neil | last post: by
1 post views Thread by BillCo | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.