I'm trying to connect Access 2007 to Oracle 11.2.0.4 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.
Thanks.