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

You can't create a DBLink to an ODBC data source. That's for client access only. I think you need to buy one of Oracle's gateway products to do what you want to do.

If you just want to move data, you could use something like Access or Powerbuilder to connect to both databases (using ODBC) and transfer data between them.

cbakotc_at_my-dejanews.com wrote:

> 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 Sun Aug 16 1998 - 11:11:45 CDT