Excel 2010 64 bit
Windows 7 64 bit
Oracle instant client 126.96.36.199 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.