This discussion is archived
7 Replies Latest reply: Jun 27, 2012 6:53 AM by misi RSS

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

misi Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points