If you're running an Oracle database on a UNIX or Linux platform and want to read or write data in a remote Microsoft Access database, you can use Oracle's Heterogeneous Services (DG4ODBC or HSODBC) and the ODBC-ODBC Bridge.
Oracle's Heterogeneous Services lets you use Oracle SQL to transparently access data stored in non-Oracle systems as if the data was stored within an Oracle server.
Oracle 9i and Oracle 8i users can find detailed instructions on how to set this up in the following article Accessing ODBC and JDBC data dources from Oracle Heterogeneous Services (HSODBC).
Oracle 10g (and later) users can refer to Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC). Although this document describes how to connect Oracle to a remote SQL Server database, the process is the same for Microsoft Access. In the Install, configure, and test the ODBC driver section, configure an ODBC-ODBC Bridge client data source that points to a system ODBC data source for the target Access database.
You can also use the ODBC-ODBC Bridge to connect to any other remote Windows database from Oracle.
You can find other ODBC drivers that you can use with Oracle's Heterogeneous Services here.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
