IBM Support

The specified DSN contains an architecture mismatch between the Driver and Application

Question & Answer


Question

Attempting to configure and use ODBC data sources in Modeler and receiving the following error: "The specified DSN contains an architecture mismatch between the Driver and Application"

Cause

This error can occur if the ODBC driver you are using does not match the bit level of Modeler. So for example, if the ODBC drivers are 32 bit and Modeler is 64 bit, or vice versa. This error can also occur if you use the wrong version of ODBC Administrator to try to configure an ODBC driver that does not have the same bit level.

Answer

So to manage a data source that connects to a 32-bit driver under a 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. And then also make sure that whatever bit level is used for your ODBC driver, be sure to use the same matching bit level for Modeler. So always use 64 bit drivers with 64 bit Modeler and 32 bit drivers with 32 bit Modeler.

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21677503