Re: Database link from Access to Oracle

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 Received on Tue Nov 07 2000 - 14:25:21 CST