Error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting via DataServer for MS SQL Server

Error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting via DataServer for MS SQL Server

- Using the SQL Server ODBC driver
- OpenEdge version used is 32-bit
- OpenEdge version used is 64-bit

 

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.
or
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.

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.