|
|
Posted by robertino on 01/20/06 12:01
Hi all,
I'd like to know what the best means available is to enable distributed
queries from a SQL Server 2000, on tables in BOTH SQL Server 2000 and a
remote DB2 server (the latter is not yet available for testing).
So, I would be wanting to write queries or SP's like:
select t1.field1, t1.field5, t1.field6, t2.field55, t2.field22
from MySQLServer.mydb.dbowner.tableXXX as t1
inner join ThatDB2Server.thatdb.thatowner.tableYYY as t2 on t2.field11
= t1.field99
where t1.field44 = @foobar
I'm aware of at least two ways to go here:
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?
(c) Is there another way(s) to go about this task?
HYCH,
Rob
Navigation:
[Reply to this message]
|