My Oracle Support Banner

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 JUNE 08, 2023

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.