ODBC Architecture mismatch

user12849379

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.

Sdhamoth-Oracle

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.

Thanks,

Senthil