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?

Status
Not open for further replies.

crjones

Programmer
Jan 26, 2004
9
US
Have been having a difficult time getting a connector to work between Microsoft Sql Server 2000 and IBM DB2 Universal Database, over TCP/IP, both running on Win 2K machines. Has anyone had any success?
 
According to SQL Server's BOL:

The Microsoft OLE DB Provider for DB2, distributed with Microsoft® Host Integration Server 2000, allows Microsoft SQL Server™ 2000 distributed queries to query data in DB2 databases.

So I guess this means you need Microsoft's Host Integration Server to make it happen.



Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson
 
I wish it was that easy.
Have tried MS, Hit, DataDirect,
All have various problems.
HiT has been the most willing to work with us so far.
Will continue and post what we find.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top