Linked Server

Last Post 22 Feb 2008 10:03 AM by rayan127. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
rayan127
New Member
New Member

--
22 Feb 2008 09:26 AM
I have SQL Server 2005 installed on server "HULK" and DB2 installed on server "HEMAN" . I want to create linked server in HULK to read data from the HEMAN Server(DB2). I have created the System DNS on HEMAN by the name "DB2TEST". The Database name is "SAMPLE" and the Schema is "SYSTEM".

Does anyone give me the steps to create the linked server?
Does anyone give me the parameter values for the SP "sp_addlinkedserver"?

Thanks in advance.
SQLUSA
New Member
New Member

--
22 Feb 2008 09:57 AM
Why don't you use the GUI in Object Explorer of Management Studio?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/bestpractices...innerjoin/ The Best SQL Server 2005 Training in the World!
rayan127
New Member
New Member

--
22 Feb 2008 10:03 AM
What should i enter in the field - Provider, Product name, Data Source, Provider string, Location and catalog? Could you please give me the values?
rayan127
New Member
New Member

--
22 Feb 2008 11:01 AM
Both SQL Server and DB2 are on Windows platform.
I can create the linked server on the same server. (Both SQL Server and DB2 are on the same Machine).
i used - EXEC sp_addlinkedserver @server = N'DB2', @provider=N'MSDASQL', @datasrc=N'DB2Test' - DB2Test is the DNS

But i want to create linked server to DB2 installed on different server. How can i do that?
What should i enter in the field - Provider, Product name, Data Source, Provider string, Location and catalog?


Acceptable Use Policy
---