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

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

Re: Is third party software necessary to use Heterogenous

From: Tim Gorman <tim_at_sagelogix.com>
Date: Fri, 16 May 2003 13:43:09 -0800
Message-ID: <F001.0059B83D.20030516134309@fatcity.com>


You can download Oracle ODBC drivers for free from "http://otn.oracle.com/software/tech/windows/odbc/content.html". You can download Sybase ODBC drivers for free from "http://www.sybase.com/detail_list_multi/1,6902,11662,00.html?dynamic_query_ yn=N&dropdown_product=2361"...

Sorry about the wrapping of URLs, but all your really need is "otn.oracle.com" and "www.sybase.com" anyway...

on 5/16/03 1:55 PM, JayMiller_at_TDWaterhouse.com at JayMiller_at_TDWaterhouse.com wrote:

> 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: Tim Gorman
  INET: tim_at_sagelogix.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 - 16:43:09 CDT

Original text of this message

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