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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can anyone suggest a connector between MS Sql and IBM DB2?
- Thread starter crjones
- Start date
SonOfEmidec1100
Technical User
Cant help directly (DB2 one of lifes many mysteries to me) but Microsoft provide an oledb driver so you can create a linked server, theres an example in SQL BOL under sp_AddLinkedServer
EXEC sp_addlinkedserver
@server='DB2',
@srvproduct='Microsoft OLE DB Provider for DB2',
@catalog='DB2',
@provider='DB2OLEDB',
@provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'
Theres also this link
Maybe helpfull....
EXEC sp_addlinkedserver
@server='DB2',
@srvproduct='Microsoft OLE DB Provider for DB2',
@catalog='DB2',
@provider='DB2OLEDB',
@provstr='Initial Catalog=PUBS;Data Source=DB2;HostCCSID=1252;Network Address=XYZ;Network Port=50000;Package Collection=admin;Default Schema=admin;'
Theres also this link
Maybe helpfull....
- Status
Similar threads
- Locked
- Question
