7 Replies Latest reply: Jun 27, 2012 8:53 AM by misi RSS

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


      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 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!