ODBC on Teradata on VM

Teradata Database on VMWare

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!
3 REPLIES
Enthusiast

Re: ODBC on Teradata on VM

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.

Re: ODBC on Teradata on VM

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!

Teradata Employee

Re: ODBC on Teradata on VM

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