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.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21677503