RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

Connectivity
N/A

RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

Hi all,

I am currently trying to configure Teradata 15.0 client on a RHEL7 machine.  First I installed tdicu, TeraGSS, then tdodbc.  Then I edited the .odbc* to my Teradata credential and DBC etc. The .odbc.ini and .odbcinst.ini are at my $HOME dir.

When I test the connection using tdxodbc, the following error return:

[ags@Dev03273 msg]$ export NLSPATH=/opt/teradata/client/15.00/odbc_64/msg/tdodbc.cat

[ags@Dev03273 msg]$ cd ../bin/

[ags@Dev03273 bin]$ ./tdxodbc

Enter Data Source Name: teragdb4

Enter UserID: qatest1

Enter Password:

Connecting with SQLConnect(DSN=teragdb4,UID=qatest1,PWD=*)...

adhoc: (SQL Diagnostics) STATE=IM003, CODE=0, MSG=[DataDirect][ODBC lib] Specified driver could not be loaded

ODBC connection closed.

If someone know what configuration I did wrong?

4 REPLIES

Re: RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

Hi:

Try adding:

LD_LIBRARY_PATH=/opt/teradata/client/15.00/odbc_64/lib

export LD_LIBRARY_PATH

HTH

Cheers.

Carlos.

N/A

Re: RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

I did that.  Same problem...

N/A

Re: RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

export LD_LIBRARY_PATH=/opt/teradata/client/ODBC_64/lib:$LD_LIBRARY_PATH

[ags@Dev03273 ~]$ ldd /opt/teradata/client/ODBC_64/lib/tdata.so

        linux-vdso.so.1 =>  (0x00007fff71974000)

        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fefdc016000)

        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fefdbdff000)

        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fefdbbe3000)

        libdl.so.2 => /lib64/libdl.so.2 (0x00007fefdb9df000)

        librt.so.1 => /lib64/librt.so.1 (0x00007fefdb7d6000)

        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fefdb5bd000)

        libodbcinst.so => /lib64/libodbcinst.so (0x00007fefdb390000)

        libtdparse.so => /lib64/libtdparse.so (0x00007fefdb1f5000)

        libicudatatd.so.46 => not found

        libicuuctd.so.46 => not found

        libm.so.6 => /lib64/libm.so.6 (0x00007fefdaef2000)

        libc.so.6 => /lib64/libc.so.6 (0x00007fefdab31000)

        /lib64/ld-linux-x86-64.so.2 (0x00007fefdc6a9000)

        libddicu27.so => /lib64/libddicu27.so (0x00007fefd9c3a000)

Looks like some libraries are missing from the teradata client install?

Teradata Employee

Re: RHEL7 Teradata client 15.00 cannot connect: Specified driver could not be loaded

Those "missing" files are part of the tdicu package and should physically be in /opt/teradata/client/15.00/tdicu/lib64 with links in /usr/lib64.

Did tdicu install correctly? Is /usr/lib64 in your LD_LIBRARY_PATH?