Hi, I have had a search through the forums (and google) and have found plenty of discussions about teradata ODBC drivers, but none that seem to quite match the issue I am seeing....
I have a SQL Server 2008 R2 instance running on a Windows Server 2008 VM, and after some intial issues (the readme appears to give the installation order for the gss and icu prerequisties in the wrong order?) have managed to get the 32 and 64 bit ODBC drivers installed, and I am able to setup DSN's in the ODBC administrator.
However when I attempt to create an ODBC connection manager in SQL Server Integration Services (SSIS) using these DSN entries I get an error message that reads:
Test connection failed because of an error in initializing provider. Error [IM003] Specified driver could not be loaded due to system error 193: (Teradata, D:\Apps\Teradata\Client\14.00\ODBC Driver for Teradata\Lib\tdata32.dll).
Does anybody have any suggestions as to what might be happening here?
ICU and ODBC installations modify the PATH environmental variable. I am guessing that the ODBC driver cannot load the ICU DLL(s). Did you restart SIIS and/or OS?