Hello, I'm trying to create a connection of my Oracle db with ms access, so I want to read some access tables from my oracle user, using an odbc connection and a dblink, I dont have information about It, can you explain me the process step by step or can you give me a document to do It ??
I used to do It with a fox pro database, and now I don't know how to repeat the process with access.
Heterogeneous Services - Generic Connectivity In Oracle9i
Oracle9i, like previous versions, supports heterogeneous services to allow data
in non-Oracle database to be queried using SQL. This support has been in the form
of transparent gateways, which are vendor specific, or generic connectivity which
uses ODBC or OLEDB to make the connections. The functionality supported by generic
connectivity is typically more limited than that possible when using vendor specific
gateways, but it is quick and simple to configure. The steps listed below can be used
to connect Oracle to any ODBC compliant database (MS Access, SQL Server etc.) on the
Make sure a valid username and password are present for the non-Oracle database
Create an ODBC DataSource for the non-Oracle database (Access1).
Create a file called: ORACLE_HOME\hs\admin\initACCESS1.ora which contains:
HS_FDS_CONNECT_INFO = Access1 #ODBC DSN
HS_FDS_TRACE_LEVEL = OFF
Add the following entry to the tnsnames.ora file:
Add the following entry into the listener.ora file: