Tuesday, March 21, 2017

Connection from SQLA 15.10 fails - "0: Loading the Teradata ICU Library Failed. Error is 126"


Problem  :

In SQL Assistant, when ODBC is selected and a connection is attempted, a popup
is thrown:

0: Loading the Teradata ICU Library Failed. Error is: 126

.Net connections from SQLA work correctly. Shared ICU for 32bit is shown as installed on TTUListProducts.

Environment/Conditions/Configuration :
TDBMS 15.10.01.07
Windows 8
Windows 10
TTU 15.10
Microsoft Office 2016

Cause :

Windows 8 has no version of the msvcr110.dll library in its 32bit directory:

C:\Windows\SysWOW64 for a 64bit system
C:\Windows\System32 for a 32bit system
ODBC requires the library to operate correctly.

Solution :
Workaround:

Locate the version of msvcr110.dll which is distributed with 32bit
TeraGSS. The location may vary slightly depending on the version of TTU installed. Prior to TTU 15.10.04, the TeraGSS components were installed in

Program Files (x86)\Teradata\Teradata GSS. Beginning with TTU 15.10.04, they were moved to Program Files (x86)\Teradata\Client\15.10\bin.

Copy msvcr110.dll from the Teradata directory to C:\Windows\SysWOW64.
Close and reopen SQL Assistant.

Additional Information :

Another symptom matches KCS001882: the error "Cannot find terasso library" is thrown when the user tries to create a new DSN or configure an existing DSN in ODBC Administrator.

1 comment:

  1. Thanks for sharing valuable information. Your blogs were helpful to Teradata learners. I request to update the blog through step-by-step. Also, find the Teradata news at
    Teradata dba Online Training

    ReplyDelete