ODBC architecture error for TPT Oracle

Tools
Fan

ODBC architecture error for TPT Oracle

Hi ,

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.

Regards,

Irfan

1 REPLY
Junior Supporter

Re: ODBC architecture error for TPT Oracle

Irfan:

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.

HTH.

Cheers.

Carlos.