Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Is third party software necessary to use Heterogenous Services Ge

Is third party software necessary to use Heterogenous Services Ge

From: <JayMiller_at_TDWaterhouse.com>
Date: Fri, 16 May 2003 12:55:43 -0800
Message-ID: <F001.0059B6CD.20030516125543@fatcity.com>


I'm trying to set up a direct connection from one of my Oracle databases to a Sybase database. Working from the documentation I read:  

"Generic connectivity is implemented as either a Heterogenous Services ODBC agent or a Heterogenous Services OLE DB agent. An ODBC agent and OLE DB agent are included as part of your Oracle 8i system. Be sure to use the agents shipped with your particular Oracle system and installed in the same $ORACLE_HOME."  
>From this I had assumed that Oracle provided everything necessary for
Generic Connectivity.  

But while trying to get it to work I came across Note 115098.1 which states that a necessary step is:  

"2) Install the 3rd party ODBC Driver"  

So is it possible to connect to a Sybase database without either paying for Transparent Gateways or installing 3rd party software or not? Does this mean I have to pay for one or the other? Anyone out there done this before and have some idea how much it would cost?  

Thanks,
Jay Miller

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri May 16 2003 - 15:55:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US