Re: Database link from Access to Oracle

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.
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/