Solaris ODBC connection issue with teradata 12

Connectivity
Enthusiast

Solaris ODBC connection issue with teradata 12

Hi All,

Currently I'm trying to execute the sample code provided by Teradata 12 ODBC. When I execute the sample I'm getting below error message. I have installed Teradata 12 express on windows box and trying to establish the connection using ODBC code from Solaris 10. Also on the windows box I have added the Solaris IP address in the hosts file. Let me know if I'm missing any configuration settings or how to solve this issue.

-bash-3.00$ ./adhoc

Enter Data Source Name: mdowner
Enter userID:dbc
Enter password: dbc
{error} STATE=IM003, CODE=2145429361, MSG=[DataDirect][ODBC lib] Specified driver could not be loaded

LD_LIBRARY_PATH=/opt/teradata/client/odbc/drivers:/opt/teradata/client/odbc/lib:/opt/teradata/client/lib:/export/vol01/mdbuild/TdOdbc32/tdicu

ODBCINI=/export/vol01/mdbuild/.odbc.ini

The .odbc.ini contains

[ODBC]
InstallDir=/opt/teradata/client/odbc
Trace=1
TraceDll=/opt/teradata/client/odbc/lib/odbctrac.so
TraceFile=/export/vol01/mdbuild/trace.log
TraceAutoStop=0

[ODBC Data Sources]
mdowner=tdata.so

[mdowner]
Driver=/opt/teradata/client/odbc/drivers/tdata.so
Description=NCR 5500 running Teradata 12.00.00
DBCName=10.132.12.37
Username=dbc
Password=dbc
Database=dbc
DefaultDatabase=dbc
LastUser=dbc

Please let me know where the issue is, I have to solve this issue ASAP. I have also tried installing both 64 bit and 32 bit ODBC driver but the end result is same. On windows box I have no issues with ODBC code and everything is fine.

I have to establish the connection, so that I can demo a application to Sales persons.

Thanks
Shri
1 REPLY
Teradata Employee

Re: Solaris ODBC connection issue with teradata 12


do

ldd /opt/teradata/client/odbc/drivers/tdata.so

and see for what library the load fails.

Most likely it is to do with Teradata ICU libraries.