Information

Title	Trying to connect an application to ODBC drivers where the bit version is not the same

URL Name	000036134

Article Number	000159302

Environment	Product: OpenEdge Version: 10.x,11.x OS: All supported platforms

Question/Problem Description

Trying to connect an application to ODBC drivers where the bit version is not the same
Trying to connect a 64 bit application with 32 bit ODBC drivers fails with architecture mismatch error
Trying to connect a 32 bit application with 64 bit ODBC drivers fails with architecture mismatch error
32-bit Application cannot see datasource with 64-bit drivers and vice versa.
Can a 64 bit application connect to the database via 32 bit ODBC driver?

Steps to Reproduce

Clarifying Information

Error Message	The specified DSN contains an architecture mismatch between the driver and the application

Defect Number

Enhancement Number

Cause

There is a mismatch between the bit pattern of the client executable and the ODBC driver.

If the client application is 32-bit but the ODBC driver is 64-bit then this error will occur.

If the client application is 64-bit but the ODBC driver is 32-bit then this error will occur.

If the ODBC DSN has been created using %WINDIR%\System32\odbcad32.exe so the ODBC driver used in the DSN is 64-bit. The 32-bit Progress client cannot access the 64-bit ODBC driver.

If the ODBC DSN has been created using %WINDIR%\SysWow64\odbcad32.exe so the ODBC driver used in the DSN is 32-bit. The 64-bit Progress client cannot access the 32-bit ODBC driver.

Third party applications also will not be able to see or work with a datasource which contains a ODBC driver with a different bit version.

Resolution

Install the ODBC driver with the correct bit version and recreate the ODBC DSN.

If the client executable is 32-bit use %WINDIR%\SysWow64\odbcad32.exe.
If the client executable is 64-bit use %WINDIR%\System32\odbcad32.exe

On 64-bit systems the version of odbcad32.exe in %WINDIR%\SysWow64 is 32-bit and accesses 32-bit ODBC drivers.
On 64-bit systems the version of odbcad32.exe in %WINDIR%\System32 is 64-bit and accesses 64-bit ODBC drivers.

Workaround

Notes

Keyword Phrase

Last Modified Date	7/22/2016 8:04 PM