Oracle-L: RE: Heteogenous Services

From: Kevin Toepke <ktoepke_at_rlcarriers.com>
Date: Thu, 22 May 2003 10:51:51 -0800
Message-ID: <F001.005A052E.20030522105151@fatcity.com>

Peter

I think you are confusing 2 different methods of accessing non-oracle databases.

Heterogeneous Services (aka Generic Database ODBC) is the simples (and cheapest). It requires a 3rd party ODBC driver.

Transparent Gateway is the Oracle-Only Solution and should be the fastest. It is an extra-cost option ($15000 - $120000+)

we recently installed and configured Heterogeneous Services to connect to a SQL Server database from Oracle. It was quick to setup and more than fast enough for our needs. We used the DataDirect ODBC Driver.

HTH
Kevin

-----Original Message-----
Sent: Thursday, May 22, 2003 2:23 PM
To: Multiple recipients of list ORACLE-L

We are looking at using heterogenous services on Oracle 8.1.7 to Sybase. It appears to me that the transparent gateway is all that is required. The confusion results from a test environment that was built by another DBA who installed the generic connectivity configuration which requires a separately purchased ODBC driver for Unix. This environment works.

The question is whether, or not, the ODBC driver is necessary for the transparent gateway configuration. The data and documentation say, 'no' but we have experience that says otherwise. Comments from anyone with hands on experience with the transparent gateway would be appreciated.

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Peter Barnett
INET: regdba_at_yahoo.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Kevin Toepke
INET: ktoepke_at_rlcarriers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------