Re: Attaching to Oracle and an ODBC db at the same time.

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: 1997/11/20
Message-ID: <34740a21.1862828@read.news.global.net.uk>#1/1

On 19 Nov 1997 22:10:13 GMT, cmcantie_at_utmb.edu [Cathy] wrote:

>Is it possible to attach to an Oracle database and also link to another
>database (like Access) at the same time and be able to perform queries that
>link tables from both places? I am using Oracle 7.3 on NT all tools are on
>Win95 PC using SQL*Net v2.
>

The easiest way is to install the oracle odbc driver and attach the tables using the Access Get External Data... menu option.

You do have to be very careful about joins between tables and about the sql statements you issue to avoid the entire oracle database being transferred to the client pc. Received on Thu Nov 20 1997 - 00:00:00 CST