Archives of the TeradataForum
Message Posted: Wed, 16 Sep 2009 @ 20:06:10 GMT
Subj: | | Solaris ODBC connection issue with teradata |
|
From: | | Shrihari Saraf |
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: mdowner
Enter password: mdowner
{error} STATE=IM003, CODE=2145429361, MSG=[DataDirect][ODBC lib] Specified
driver could not be loaded
The contain of odbc.ini file is
[ODBC]
InstallDir=/opt/teradata/client/odbc
Trace=1
TraceDll=/opt/teradata/client/odbc/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
[ODBC Data Sources]
mdowner=tdata.so
[mdowner]
Driver=/opt/teradata/client/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V1R5.2
DBCName=10.132.3.71
DateTimeFormatSessionMode=Teradata
SessionMode=ANSI
Username=mdowner
Password=mdowner
Database=mdowner
DefaultDatabase=mdowner
LastUser=mdowner
UseXViews=Yes
Shrihari Saraf . Manager
Ness Technologies
|