Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Heterogeneous Services

RE: Heterogeneous Services

From: Sweetser, Joe <>
Date: Wed, 24 Oct 2007 08:29:03 -0600
Message-ID: <E323160E08E560459CD05A883546C3CE0AA64BF9@earthquake.ICAT.COM>

Thanks to all for the suggestions/hints/advice. They will all be helpful once I get this particular database up to 10g because, according to Metalink Note 261726.1, generic connectivity is not available on Linux until 10g. This was "verified" by checking a 10g installation and seeing the $ORACLE_HOME/bin/hsodbc program while my 9i installation does not have it. One of those situations where a feature is supported on non-Linux platforms earlier than Linux....sigh.

Again, thanks for all the help.


-----Original Message-----
[] On Behalf Of Bob Sent: Tuesday, October 23, 2007 6:04 PM
Subject: Re: Heterogeneous Services

I asked a similar question here a while back (HSODBC connection to informix), admittedly the initial googling and metalinking seemed circular... I found this document to work perfectly 245549.1 . Be sure to follow it to the letter, its actually easier to do than than the document makes it sound. This also assumes you will aquire 3 party (your system) odbc drivers.

note 245549.1 = How to setup generic connectivity - HSODBC - on (your platform) in this case Sun solaris

HSODBC = hetrogeneous services via odbc


"Oracle error messages being what they are, do not highlight the correct
cause of fault, but will identify some other error located close to
where the real fault lies."

Sweetser, Joe wrote:

> Hi all -
> I am in the "conception" stage of setting up Heterogeneous Services
> from a Linux database to a MSSQL 2000 (v 8.00.2039) database.
> need to pull data from MSSQL into Oracle. I've been OTN'ing,
> metalink'ing and google'ing but am still fuzzy about exactly what I
> to do. Figure 7-1 in
> 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:
> 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
> If so, any vendor/freeware/shareware recommendations are appreciated.
> I've been poking around the 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.
-- 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. --
Received on Wed Oct 24 2007 - 09:29:03 CDT

Original text of this message