Re: Oracle 7 and non-Oracle NT System DSN data w/ database links

OK, you can't have an Oracle database talk to a non-Oracle database thru ODBC (or not without getting very, very complicated, anyway). You need a piece of Oracle software called the Oracle Transparent Gateway for Ingres. This software makes Ingres *look* like another Oracle database, so with this installed and running on your Ingres box, you can then create a dblink that points to the Ingres db.

Good luck,
Dave

cbakotc_at_my-dejanews.com wrote in message <6r2a8p$q3d$1_at_nnrp1.dejanews.com>...
>I have created a System DSN pointing to a non-Oracle datasource (Ingres) on
my
>local machine, and can successfully connect and view data from the Oracle
32-
>bit ODBC TEST program by double clicking on the new DSN's name.
>
>Now, I want access to the non-Oracle table from my Oracle database. Can
>someone please explain the procedure for creating the connection between
the
>two. From the Oracle <-> Oracle connections I have made in Schema Manager
>before, I would assume that it has something to do with creating a
"Database
>Link" in Oracle and possibly setting a SQL*Net name. However, in the case
of
>a non-oracle datasource, I do not know how to create the link.
>
>Info (from my Oracle Installer):
>Oracle 7 Workgroup Server: 7.3.4.0.0
>Oracle 7 32 Bit ODBC Driver: 2.5.3.1.0B
>SQL*NET Client: 2.3.4.0.0
>SQL*NET Server: 2.3.4.0.0
>
>TIA-
>-chris
>
>
>===========================================================================
=
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Aug 14 1998 - 21:22:36 CDT