Posted by trimar on 01/21/06 11:54

robertino wrote:

> 1) in SQL Server 2000, create a linked server to the remote DB2
> server, either using the wizard or sp_addlinkedserver, and using either
> an OLEDB or ODBC connection;
>
> 2) using MS Host Integration Server (HIS).
>
> Since I've only just today learnt about HIS, I don't know very much
> about it.
>
> Questions:
> (a) are options (1) and (2) mutually exclusive, or does one depend on
> the other?
> (b) can I do (1) without having to bother with (2)? If this, where
> would I get hold of the required OLEDB/ODBC Provider?
It depends :) If you would like to use Microsoft OLEDB Provider for DB2
you have to use HIS but there are third party OLEDB drivers like
http://www.hitsw.com/products_services/sqldb2/oledbdb2/oledbdb2_dsheet.html
or IBM OLEDB provider. I worked with IBM and HIS provider for linked
servers and everything went OK but i was using only openquery to access
data not joins with tables from DB2.


Lukasz

[Back to original message]