RE: DB link for nonoracle databases

Hi,

2 Metalink notes you might find useful:
114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC"
109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT

Also, as far as I know, Heterogeneous Services only works with 8.1.6 and above.

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
Sent: Thursday, 3 May 2001 23:46

Deepender Kr Gupta schrieb:
>
> Hi All !!
>
> I have a DBA question. Can we make a DB link for nonoracle databases ! The
> answer is
> 'YES' , I know. But How.
>
> The documentation says you will have to use Oracle
> hetrogeneous services. There is no explaination any
> further.
>
> I want my Oracle database to gather data from a SQL
> server . Both are on NT.
>
> Thanks in Advance.
>
> Deepender

Hi,

check the following documentation set:

Oracle8i Distributed Database Systems
Part III
Heterogeneous Services Concepts and Administration

You have to distinguish 2 kinds of Heterogenous Services: Transparent Gateway and Generic Connectivity.

Transparent Gateway has to be purchased seperately and offers 2 services:
SQL access to non-Oracle data sources (like DB2 e.g.) and transaction services, meaning
that e.g. DB2 tables might be included in Oracle transactions.

Generic Connectivity comes with Oracle Server (at least the EE). It allows you to
connect to ODBC and OLE DB data sources (like Excel Sheets or e.g. DB2 through ODBC).
Oracle has to be run on NT/2000. Connecting to other databases via the ODBC/OLE DB gateway gives you the
ability of accessing external data like tables. We tried it, it works fine and is in my opinion a good
and cheap solution for data transfers (unless you have any high volume / online needs).

-- 
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
AMS-Gebäude: E6 R08
Tel.: 0211/533-4893
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).