Sagent:-ODBC for mysql fail with Sagent dataflow

Product Feature: Installation / Upgrade
 

Issue

ODBC for mysql fail with Sagent dataflow

Cause

Customer getting error "The specified DSN contains an architecture mismatch between the Driver and Application"? 

Resolution

UPDATED: April 10, 2017
You will get this error if you attempt to do the following on a 64-bit Windows machine: 
 
Connect a 64-bit application to a data source for a 32-bit ODBC driver. 
Connect a 32-bit application to a data source for a 64-bit ODBC driver. 
If you are using a 64-bit application, it will be linked against the 64-bit version of the Microsoft ODBC Driver Manager, which can only load a 64-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 64-bit ODBC Data Source Administrator (accessible from Administrative tools in Control Panel). 
 
Similarly, if you are using a 32-bit application, it will be linked against the 32-bit version of the Microsoft ODBC Driver Manager, which can only load a 32-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 32-bit ODBC Data Source Administrator (accessible by running %windir%\syswow64\odbcad32.exe in the Windows Run dialog box). 
 
If an ODBC driver is listed in both versions of the ODBC Data Source Administrator, both a 32-bit and a 64-bit version of that driver are installed. 
 
 
Customer is getting this error while creating baseview. Since Sagent Client is 32bit application so this require 32bit ODBC drivers. request customer to create OBDC driver of 32 bit using %windir%\syswow64\odbcad32.exe