Architecture mismatch error when setting up ODBC import in EP5

Issue:

While attempting to setup on ODBC import on EP5 with Windows 2008 R2 you receive the following error. SQL Error: The specified DSN contains an architecture mismatch between the Driver and Application} SQLState=}IM014} SQLNativeError=0

Resolve:

This error is caused when the DSN created for the import is a 64bit DSN. You must delete that DSN and recreate it using the 32 ODBC Administrator located at c:\windows\syswow64\odbcad32.exe