Database link from Access to Oracle

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

--
Posted via CNET Help.com
http://www.help.com/