Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link DB2 from SQLServer 2000

Status
Not open for further replies.

Geoka

Programmer
Jul 16, 2001
49
US
Hi all,

I would like to know, how to connect to DB2 from SQL 2000 through the linked server Concept. which data source should i use (ODBC/OLEDB)? which one will be better?
Plz help me with an example.

Thanx
 
You'll want to install the DB2 drives on the SQL Server, then you should be able to see the DB2 drive in the drop down menu.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top