RE: Heterogeneous Services
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <orcl@xxxxxxxxxxx>
- Date: Wed, 24 Oct 2007 08:29:03 -0600
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.
-joe
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bob
Sent: Tuesday, October 23, 2007 6:04 PM
Cc: oracle-l@xxxxxxxxxxxxx
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
hth
Bob
--
"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
(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.
>
--
//www.freelists.org/webpage/oracle-l
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
