ODBC connection from Oracle to Access

[Tranman]

Can someone please help me? I need to make an ODBC connection from SQL*PLUS to Access so that I can query/update Access tables. I am not talking about connecting from Access to Oracle--I've been doing that for years.

I did this a long time ago, and it worked very well for what I wanted to do, but I have forgotten (over 50), what connection string I used to hook into the ODBC DSN. The best I can recall is that I did something like &quot;<something>@ODBC:<dsn name>&quot;????? whatever

I assume this would be the same connection string you would use for any ODBC connection.

Any help would be appreciated.

Tranman

 

[Turkbear]

Hi,
Visit

http://tahiti.oracle.com

and search the docs for 'heterogeneous'in the Net8 Admin guide
( If you have not registered for Technet, you may need to do so - its free and a very good resource)
There should be info on setting up an entry in your tnsnames.ora file ( I think just that one) that will use your ODBC DSN ...