Re: Database link from Access to Oracle

In article <t0jduig5qbir3d_at_corp.supernews.com>,   mick <msa_at_propack-data.com> wrote:
> Thanks for your help.
> Anyway, I have been told that it's not possible to create a link from
> oracle to a non-oracle database, thus your method from access to
 oracle is
> probably one of the few existing. I definitely have to drop my idea
 of a
> SQL script.

Actually, you can make a database link to a non-Oracle database using one of the Oracle Transparent Gateways. Info at <http://otn.oracle.com/products/gateways/>

> Mike
>
> Brian Tkatch wrote:
> >
> >
> > On Tue, 07 Nov 2000 19:30:09 -0000, mick <msa_at_propack-data.com>
 wrote:
> >
> > >Hi everyone,
> > >
> > >I need to establish a connection between an oracle DB and an
 Access DB.
 My
> > >interface has to be in SQL. But there is no way I can find any
 information
> > >on how to set up a database link with an ODBC.
> > >Here is the code I tried but I get an error "ORA-12154: TNS:could
 not
> > >resolve service name".
> > > create database link DBLINK using 'C:\ABC\MyAccessDB.mdb';
> > > //this statement is working because the database link is created
 in
 the
> > >Oracle DB
> > > select id from table_at_DBLINK
> > > //but it seems it can not access the database
> > >So I decided to create an ODBC with my Access Table, but I have no
 clue
 how
> > >to set up the link in Oracle with SQL and then how to access the
 database.
> > >I would be grateful for any help,
> > >Thanks,
> > >Mike
> > >
> > It is really slow, but you can setup ODBC on the machine and then
 have
> > Access "link" a table from Oracle. I use it all the time, and it
 works
> > well.
> >
> > Brian
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.