UPGRADE 12 to 13

Connectivity
Enthusiast

UPGRADE 12 to 13

We have upgraded from 12 to 13 ODBC driver on linux , since then we were not able to connect to teradata.

what are the missing thing could be.
10 REPLIES
Teradata Employee

Re: UPGRADE 12 to 13


What was the exact error ?

Make sure, you have TTU13 TeraGSS and ICU installed.
Enthusiast

Re: UPGRADE 12 to 13

we are using some application which uses the ODBC to connect to teradata.
that is not able to connect to teradata DB.

And don't know, how to test the ODBC driver from linux prompt..any help will be appreciated.

Teradata Employee

Re: UPGRADE 12 to 13

- Install 13.0 Teradata ICU, TeraGSS and ODBC pkgs. in sequence.
- set ODBCINI environment variable to point to your odbc.ini, for example,

export ODBCINI=/opt/teradata/client/ODBC_64/odbc.ini

- Update DBCName entry under [testdsn] in $ODBCINI file, to point to your Teradata database. Supply database name or IP-address. For example, your [testdsn] section in odbc.ini looks like

[testdsn]
Driver=/opt/teradata/client/ODBC_64/lib/tdata.so
Description=Teradata running Teradata V1R5.2
DBCName=teradatadev<\b>
LastUser=
Username=
Password=
Database=
DefaultDatabase=

- export NLSPATH environment variable,

export NLSPATH=/opt/teradata/client/13.0/odbc_64/msg/%N.cat

- run the sample application installed by ODBC Driver pkg,

/opt/teradata/client/13.0/odbc_64/samples/C

- When it prompt, supply the DSN name(for example testdsn), database user name and password. The sample application connects to database, and can take SQL request input, execute and display the results.
Enthusiast

Re: UPGRADE 12 to 13

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

ODBC connection closed.
Enthusiast

Re: UPGRADE 12 to 13

STATE=HY000, CODE=0, MSG=[Teradata][ODBC Teradata Driver] Major Status=0x04bd Minor Status=0xe0000007-[terasso]Cannot load TDGSS library.
Enthusiast

Re: UPGRADE 12 to 13

any help on this error ?
Teradata Employee

Re: UPGRADE 12 to 13


You can verify the reason for load failure, if you do

ldd /usr/teragss/suselinux-x8664/client/lib/libtdgss.so

Re: UPGRADE 12 to 13

We do have same issue.

ldd /usr/teragss/redhatlinux-i386/client/lib/libtdgss.so
linux-gate.so.1 => (0xffffe000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf7e15000)
libdl.so.2 => /lib/libdl.so.2 (0xf7e11000)
libc.so.6 => /lib/libc.so.6 (0xf7cce000)
libresolv.so.2 => /lib/libresolv.so.2 (0xf7cba000)
/lib/ld-linux.so.2 (0xf7fa4000)

Re: UPGRADE 12 to 13

What does this mean ?