This discussion is archived
5 Replies Latest reply: Nov 1, 2012 12:07 AM by yoonas RSS

Connect 64bit Excel to 64bit Oracle

970926 Newbie
Currently Being Moderated
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.

Legend

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