I want to connect Oracle to access and get some data from access to oracle.
my servers has the following spec:
1- OS=Oracle Enterprise Linux 5.4 -64bit
2- Database= Oracle 220.127.116.11 64bit
3- unixODBC which is installed by oracle validate
1- OS =Windows 32bit
2- Database= Access
I find a document in address http://www.dbapool.com/articles/06280701.html
how could i config unixODBC which is installed by oracle validate?where is config file?
When you want to link MS Access and an Oracle database you first need to think about the driving site. You can link an Oracle table into MS Access which would require to have an Oracle ODBC driver installed, but you can also link a MS Access table into the Oracle database which would require the Database Gateway for ODBC (also called Heterogeneous Services for ODBC in releases prior Oracle 11) and a suitable 3rd party ODBC driver which can connect to the MS Access database.
According to the header you want to connect from your Oracle database to MS Access. So you need to use the Database Gateway for ODBC. DG4ODBC is available for several Unix platforms and also for MS Windows. When you use DG4ODBC on Unix you commonly need an ODBC Driver Manager (unixODBC) and the real ODBC driver which can connect to the MS Access database. I'm only aware of one ODBC driver on Unix that allows you to handle MS Access mdb files, it is from http://mdbtools.sourceforge.net/. BUT please be aware that this driver is NOT DG4ODBC compliant as it misses some required ODBC functions. For example the version I tested didn't return the correct result for the ODBC function SQLNumResultCols which is mandatory for DG4ODBC. So from this point of view using DG4ODBC on Unix can't be used (with this ODBC driver).
The better approach that will work is to set up DG4OBC on Windows and to use the MS Access ODBC driver. This ODBC driver will at least allow you to access the MDB file. The connect flow is:
Your Oracle database on Unix connects to the DG4ODBC installation on Windows which will then load the MS Access ODBC driver and this ODBC driver will then connect to the MDB file of your choice.