SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'
Using a 64bit ODBC connection when using a 32bit application.
Create the ODBC using the 32bit ODBC connection manager located in the %WINDIR%\SysWOW64\ folder with the name odbcad32.exe
Keep in mind, this error has to do with the application using the ODBC DSN, not the systems itself. I initially ran across this issue while testing MSDTC connections using the DTCTester.exe utility. This is a 32bit utility so it has to use a 32bit ODBC dsn.