Heterogeneous Services

Hi all -

I am in the "conception" stage of setting up Heterogeneous Services (HS)
from a 9.2.0.8 Linux database to a MSSQL 2000 (v 8.00.2039) database.  I
need to pull data from MSSQL into Oracle.  I've been OTN'ing, RTFM'ing,
metalink'ing and google'ing but am still fuzzy about exactly what I need
to do.  Figure 7-1 in
http://download.oracle.com/docs/cd/B10501_01/server.920/a96544/gencon.ht
m#1656 is the closest I can find to what I am trying to accomplish.
This also seems close to what I am trying to do:
http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_serve
r.htm.  The query will initiate from the Oracle side.

A few questions:

1.  Do I need to install/run an Oracle listener on the MSSQL box?
2.  Do I need to get a 3rd party ODBC driver for my Oracle/Linux server?
If so, any vendor/freeware/shareware recommendations are appreciated.
I've been poking around the DataDirect.com site so far.
3.  I see many references to the hsodbc "program".  Is this really a
program/executable or just the way to tell the listener to use the HS
that are configured in the Oracle database?
4.  Last, any pointers/links to docs are appreciated.

Thanks,
-joe

 
Confidentiality Note: This message contains information that may be 
confidential and/or privileged. If you are not the intended recipient, you 
should not use, copy, disclose, distribute or take any action based on this 
message. If you have received this message in error, please advise the sender 
immediately by reply email and delete this message. Although ICAT Managers, LLC 
scans e-mail and attachments for viruses, it does not guarantee that either are 
virus-free and accepts no liability for any damage sustained as a result of 
viruses.  Thank you.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: