IBM Support

Error testing Teradata connections: Specified driver could not be loaded due to system error 126

Technote (troubleshooting)


Problem(Abstract)

Attempting to test or use any Teradata datasource generates error message

Symptom

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


Cause

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.

Document information

More support for: Cognos Business Intelligence
Report Studio

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