DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows 7 64bit, Office 2010 32bit ODBC Connection to Oracle 10.2.0.4.0

misiMay 23 2012 — edited Jun 27 2012

Hi,

I´m using an MS-Access application (Office 2010 32bit) on a windows 7 64bit machine. The access applications needs a ODBC connection to an existing oracle 10.2.0.4.0 database but i can´t get this working...

What I tied yet:

1. Installation of the InstantClient and ODBC-Drivers for 32 & 64bit
2. Adding to the path variable
3. Creating the tnsnames.ora
4. Creating the TNS_Admin variable
5. Configuration of the ODBC-DSN für 64bit "normal ODBC-Admin" and for 32bit windows/sysWOW64\odbcad32.exe

When I tried to link oracle database tables to the MS-Access application it seems that the dialog only get the 64bit versions....???? Is there any existing workaround?
Is is possible to use Windows7 64bit with Office 2010 32bit to get an connection with the oracle database, or have I to use Office 2010 64bit???

Thanks for any suggestions!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2012

Added on May 23 2012

#odbc, #windows-and-net

7 comments

13,223 views