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

From: <cbakotc_at_my-dejanews.com>
Date: Fri, 14 Aug 1998 21:30:02 GMT
Message-ID: <6r2a8p$q3d$1@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 - 16:30:02 CDT