All Forums Teradata Database on VMWare
pinkus05 2 posts Joined 08/16
05 Aug 2016
ODBC on Teradata on VM

I'm trying to connect to Teradata Express on Vmware, and I get this error: {error} STATE=01000 CODE=0 MSG=[unixODBC][Driver Manager]Can't open lib '/opt/teradata/client/odbc/tdata.so' : file not found
I do not see tdata.so on my system so I guess I do not have ODBC drivers installed on Teradata Express? I this the correct assumption?

TVME:/tmp/tdicu1510 # rpm -qa | egrep -i "tdodbc|tdicu|teragss"

TeraGSS_linux_x64-15.10.02.04-1

tdicu-15.00.00.00-1

 
Thus, I tried to install: https://downloads.teradata.com/download/connectivity/ odbc-driver/linux
I was able to upgrade TeraGSS_linux, but when I tried to upgrade tdicu, I get the following:

TVME:/tmp/tdicu1510 # rpm -Uvh tdicu1510-15.10.01.01-1.noarch.rpm

error: Failed dependencies:

        pdegpl conflicts with tdicu1510-15.10.01.01-1.noarch

 

Can anyone assist on how to proceed and if I'm on the right track?

 

Thanks!
 
 
 

Johannes Vink 28 posts Joined 08/14
06 Aug 2016

If I remember it correct tdicu is listed as a dependency for tdodbc, but I never installed it. tdicu is for some language dependend messages. We stayed on English and no problems so far.

pinkus05 2 posts Joined 08/16
26 Aug 2016

Thanks Johannes!
I did try to install it with nodeps, so now I have:
# rpm -qa | egrep -i "tdodbc|tdicu|teragss"
TeraGSS_linux_x64-15.10.02.04-1
tdicu-15.00.00.00-1
tdodbc1510-15.10.01.02-1
 
So it looks good… but when trying to connect to it, I get: [unixODBC][Driver Manager]Can't open lib '/opt/teradata/client/odbc/tdata.so' : file not found
 
So, I try to find the file, and I get:
 
# find / -name tdata.so
/opt/teradata/client/15.10/lib64/tdata.so
/opt/teradata/client/15.10/lib/tdata.so
 
How do it point it to the correct dir?
# env | grep -i odbc
PWD=/opt/teradata/client/ODBC_32/lib
OLDPWD=/opt/teradata/client/ODBC_32
 
# cat /opt/teradata/client/15.10/odbc_64/odbc.ini
[ODBC]
InstallDir=/opt/teradata/client/15.10/odbc_64
Trace=0
TraceDll=/opt/teradata/client/15.10/odbc_64/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0
 
[ODBC Data Sources]
testdsn=tdata.so
 
[testdsn]
Driver=/opt/teradata/client/15.10/odbc_64/lib/tdata.so
Description=Teradata database
DBCName=
LastUser=
Username=
Password=
Database=
DefaultDatabase=
 
 
# cat /opt/teradata/client/15.10/odbc_64/odbcinst.ini
[ODBC DRIVERS]
Teradata=Installed
 
[Teradata]
Driver=/opt/teradata/client/15.10/odbc_64/lib/tdata.so
APILevel=CORE
ConnectFunctions=YYY
DriverODBCVer=3.51
SQLLevel=1
 
Can you let me know what I’m missing? Thanks!

Fred 1096 posts Joined 08/04
28 Aug 2016

Try setting ODBCINI and/or ODBCINST to make sure those are the ini files you are actually using, e.g.
ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini

You must sign in to leave a comment.