All Forums Tools
xie407 2 posts Joined 04/10
20 Apr 2010
PT job with Oracle and Informix ODBC operator error

Hi,erveryone
I have a problem in using TPT. When i use the Oracle or informix ODBC operator in my a teradata PT job i received a ODBC connect error
or ODBC driver error.

The following is my machine description:
1: Redhat linux 2.6.9
2: Software:
Informix CSDK 2.9
Oracle database 10g
Freetds0.82
TTU 13.00.00.2

perl 5.8.8
DBI 1.608
DBD-ODBC-1.23
unixODBC-2.2.14-p2

The following is my test step:
1: When i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32 and $ODBCINI=/opt/teradata/client/13.0/odbc_32/odbc.ini,
but when i install perl DBD-ODBC i set $ODBCHOME=/usr/local/unixODBC/ect

1:Then i test teradata ODBC DBD-ODBC i get a segament fault.
2:I test ORACLE and Informix perl DBD-ODBC script is successful
3:I test my PT job with Oracle or Informix i get the following error,this is very strange
ODBC_OPERATOR: private log specified: ODBC_rdpfc0_007.MyLog
ODBC_OPERATOR: connecting sessions
ODBC_OPERATOR: TPT17122: Error: unable to connect to data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=I, CODE=0,
MSG='['
ODBC_OPERATOR: disconnecting sessions
ODBC_OPERATOR: TPT17124: Error: unable to disconnect from data source
ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver:
STATE=0, CODE=0,
MSG='['
ODBC_OPERATOR: Total processor time used = '0.06 Second(s)'

2: When i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32 and $ODBCINI=/opt/teradata/client/13.0/odbc_32/odbc.ini,
but when i install perl DBD-ODBC i set $ODBCHOME=/opt/teradata/client/13.0/odbc_32

1:Then i can test teradata ODBC DBD-ODBC success
2:But i test ORACLE and Informix all perl DBD-ODBC script is failed
3:I test my PT job with Oracle or Informix i get the following error
{error} STATE=IM003, CODE=0, MSG=[DataDirect][ODBC lib] Specified driver could not be loaded
4:I can test my PT job with Teradata ODBC operator success

So i get my conclusion:
1: Is the TPT ODBC operator compatible other database ODBC driver has limited? I think so, because my perl can connect Oracle
and informix using ODBC interface,but my PT job with ODBC operator can not work.
2: Is the teradata odbc driver can not support my Oracle and Informix ODBC version?
3: I install FreeTDS for sybase odbc connection. And i can test PT sybase ODBC operator job successful,also i can test my perl sysbase ODBC connect success.

If you have any experence with this,please give me a hint,Think you!

feinholz 1234 posts Joined 05/08
17 May 2010

TPT and the ODBC operator are only certified with ODBC drivers from DataDirect.

Also, please indicate which version of TPT you are using.

--SteveF

xie407 2 posts Joined 04/10
23 May 2010

Thank you for your applying. My TPT version is 13.00.00.2, and i see the document this version have supported the Oracle,Sybase and Sql server ODBC operator.
I can clearly confim that i can connect Oracle database using the sample application(/opt/teradata/client/sample/adhoc).But my TPT job can not work with the
Oracle ODBC operator. If the TPT ODBC operator are not cerified with this ODBC drivers version, i am not sure.

TDUser2000 17 posts Joined 07/12
16 Dec 2014

Hi Feinholz,
To be more specific, TPT and ODBC operator are only certified with 32 -bit ODBC drivers from Datadirect?
 
Regards
 
 
 

feinholz 1234 posts Joined 05/08
16 Dec 2014

TPT 13.0 only runs in 32-bit mode, so yes we are only certified with the 32-bit versions of the drivers.
 

--SteveF

You must sign in to leave a comment.