Troubleshooting > Resolving the ODBC DSN Architecture Mismatch Error

Resolving the ODBC DSN Architecture Mismatch Error

Article #: Product: Version:

Summary

When connecting to SQL Server or another ODBC-connected database from DMExpress, the ODBC error "The specified DSN contains an architecture mismatch between the Driver and Application" indicates that there is a bit-level mismatch between the ODBC client driver and the version of DMExpress installed on the system.

To resolve the issue, ensure that you have the 32-bit Data Source Name (DSN) defined when building the task, and the 32-bit or 64-bit DSN defined when running the task, based on the bit level of DMExpress that you have installed on your system.

Symptom

When connecting to SQL Server or another ODBC-connected database from DMExpress, where there is a bit-level mismatch between the ODBC client driver and the version of DMExpress installed on a Windows system, the following error message is issued:

(DBCNNTES) database connection "<text>" to <text> data source "<text>" could not be established (ODBC_ERROR) [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Resolution

To ensure that the bit level of DMExpress and the bit level of the ODBC driver for an ODBC-connected database are the same, define the appropriate DSNs as explained in Configuring SQL Server or ODBC Connectivity on 64-bit Windows.

Last updated: