RE: Heterogeneous Services

Please note: HSODBC on Linux in 9i is not supported (or didn't use to be).

I successfully got it setup though to talk to MS SqlServer 2000 server.

Unless something has changed, you need to install a version of Oracle 10g on Linux to get the HSODBC libraries that work for Linux and run the listener from 10.x software instead of the 9.x version.

(10g Listener handles 9i service registration cleanly so there is no
issues there)

I think I used an open source ODBC driver for Linux (FreeTDS or something?). I can't remember for sure as its been a couple of years. Might have been Openlink's software.

Here's the note you want:
Note:264567.1
Subject: How To Setup Generic Connectivity - HSODBC - on Linux
(REMEMBER YOU MUST USE A 10G LISTENER - That's the only thing you need
to get this to work on 9i for Linux)

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe Sent: Tuesday, October 23, 2007 11:01 AM To: oracle-l_at_freelists.org
Subject: 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




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