DG4ODBC 11.2 on Windows 64-bit Gives Error ORA-28500 The specified DSN Contains an Architecture Mismatch Between the Driver and Application (Doc ID 1475507.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Microsoft Windows x64 (64-bit) - Version: 2008 R2
Microsoft Windows x64 (64-bit)

Symptoms

Using Oracle Database Gateway for ODBC (DG4ODBC) on Microsoft Windows x64 a SELECT fails with error ORA-28500 -

SQL> select * FROM table@dbaccess;
select * FROM table@dbaccess;
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture
mismatch between the Driver and Application {IM014}
ORA-02063:  preceding 2 lines from dbaccess

If you are trying to connect to an Access database using the 64-bit version of the Odbcad32.exe file which is located in the %systemdrive%\Windows\System32 folder then when creating the System DSN you will get the following error after trying "Add" for the Access ODBC driver -

"Driver do Microsoft Access (*.mdb)" is not available.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms