Error testing Teradata connections: Specified driver could not be loaded due to system error 126
Attempting to test or use any Teradata datasource generates error message
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0107 A general exception has occurred during the operation "attach(error code: -49)".Specified driver could not be loaded due to system error 126
Some of the ODBC driver components are installed in a "pending" state due to conflicts with existing files, and thus cannot be linked to by the driver.
Resolving the problem
The Teradata ODBC driver has three pre-requisite components that need to be installed in addition to the actual ODBC driver. These include:
- GSS (security sub system)
- TDICU (TeraData Internationalization system)
- MDAC 2.5 (comes with Windows XP/2003)
Once all these are installed, the system needs to be rebooted to ensure that all components are installed. The driver installation wizard does not prompt you to reboot.
More support for:
Cognos Business Intelligence
Software version: 10.2, 10.2.1, 10.2.2
Operating system(s): Windows
Software edition: Edition Independent
Reference #: 1341264
Modified date: 03 July 2017