I am getting this error when i am trying load data from an oracle source to an empty Teradata table.
ODBC_Operator: TPT17122: Error: unable to connect to data source
ODBC_Operator: TPT17101: Fatal error received from ODBC driver:STATE=IM014,CODE=0,
MSG='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'.
I am using Oracle 11g at source , teradata 13.10 at target and my operating system is Windows 2008 R2 64 bits.
If your Oracle 11 sits on a 32bit OS you must use the 32 bit version ODBC dll (odbcad32.exe?).
I think you can do it easily deleting the odbc connection you created with the Data Sources (ODBC) Administrative Tool and setting it up again using the 32-bit ODBC connection manager.