I'm trying to connect Access 2007 to Oracle 22.214.171.124 through an Oracle 12c client. I can create the ODBC connection with the Microsoft ODBC Administrator, but when I try to use it, I get the following error.
ODBC -- call failed
[Microsoft][ODBC Driver Manager] The specified DNS contains an architecture mismatch between the Driver and Application (#0).
Suggestions? I've tried dropping the ODBC and recreating it. I've reloaded the Oracle Client.
You may be using the 32bit MS Access. So you need to install client 32 bit version. Also configure ODBC DSN using c:\windows\syswow64\odbcad32.