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

The only way I can think of if is you link tables in the Oracle database to an access database (using Insert->Table->Link Table in access). Then do your sql from within the access database.

I'm not sure you can do it the other way around.

Regards

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.

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************