Error: "Input Data (x): The specified DSN contains an architecture mismatch between the Driver and Application"

[vijayakarthikeyan]

Environment Details

User wants to connect to a database from Alteryx Designer, so they choose the DSN (Data Source Name) from the ODBC Data Source Administrator, using the "Data Connections" window of Alteryx Input Tool. Once the DSN is chosen, the following error is thrown on the Input Data Tool:
 

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

• Alteryx Designer
  • 2019.4 +
• ODBC database connection
  • 32-bit/64-bit bitness mismatch

Cause

The issue occurs because of a mismatch between the driver version Alteryx is expecting (64 bit) and the actual driver version installed on the machine (32 bit). This causes Designer to error when 64-bit ODBC DSNs are used. However, workflows run successfully when 32-bit ODBC DSNs are used in Alteryx Designer.

The root cause of why the 64-bit drivers are missing is out-of-scope of Alteryx Customer Support. One of the reasons for this issue might be that, there are some security updates at the OS level, and those updates removed any of the drivers on the MySQL version. So this needs to be checked with the IT / Database Administrator team on why the 64-bit driver is missing.

Resolution

1. Install the 64-bit driver version for the database. Alteryx distributes some drivers through our downloads page. There are also links on the Data Sources page in the help documentation.

NOTE: Starting with Alteryx 2021.3, the 32bit ODBC option in Designer is removed from the user interface and the 64-bit option must be selected.

2. Create a new DSN using the 64-bit ODBC Data Source Administrator and the new 64-bit driver.

 

3. Use this new 64-bit DSN in Alteryx to connect to the database.
 

Additional Information

• End of Support for 32-BIT Database Connections