Hi all.
I have an Oracle Database 12.1 on an Oracle Linux box.
I need to create a database link to connect to access an MS Access database on a Windows Machine.
I have read documentation and i understand there could be several ways to achieve this. For example:
1. Install Unix ODBC on the Linux host and configure DSN (ODBC) on this host.
2. Install Oracle Heterogeneous Services (Generic) and connect from another host.
From what i read, i believe the Oracle Gateway (dg4odbc) and ODBC Driver must be both on the same machine. So if i select option 1 it means the Unix ODBC Driver must be able to read MS Access Files (.mdb). So i may either transfer these files to Linux or share them through samba for example.
In case i use option 2 on Windows i´m also confused as there will be two listeners: one for the Oracle Gateway Installation on windows and the listener for the Oracle Database on Linux, so upon creating the database link i don´t know if this will work.
Please any clarification is welcome.