5 Replies Latest reply: Nov 1, 2012 2:07 AM by yoonas RSS

    Connect 64bit Excel to 64bit Oracle

    970926
      Using:
      Excel 2010 64 bit
      Windows 7 64 bit
      Oracle instant client 11.2.0.1 64 bit

      Connecting Oracle 11gR2 64bit on Window 7 64bit

      I'm using ODBC to test my connect. When I go to test the connection between ODBC and the Oracle DB it says "Test Successful" but then when I try to use Excel to try to connect I get an Error saying "The specified DSN contains an architecture mismatch between the Driver and Application"

      At first my problem was that we were using Office 2007 but we upgraded to 2010. Once I install of 2010 was complete I was still receiving the same error. So I uninstalled the Oracle Client and then re-installed it but I am still receiving the same error.

      I'm not exactly sure what I am doing wrong with this process. If anyone could provide assistance I'd greatly appreciate it.

      Thank you,
      Ryan.