TPT ODBC

Tools & Utilities
Teradata Employee

TPT ODBC

Can someone help me to over come the below TPT ODBC error.

DDL_OPERATOR: private log not specified

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: Rows Deleted: 0

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.13 Second(s)'

 

Job step DELETE_TARGET completed successfully

Teradata Parallel Transporter Load Operator Version 14.10.00.03

LOAD_OPERATOR: private log not specified

Teradata Parallel Transporter ODBC Operator Version 14.10.00.03

ODBC_OPERATOR: private log not specified

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.02 Second(s)'

5 REPLIES
Junior Supporter

Re: TPT ODBC

Hi.

 

Which ODBC driver are you using? Only DataDirect ODBC drivers are supported.

 

Cheers.

 

Carlos.

Teradata Employee

Re: TPT ODBC

I'm using DataDirect 7.1 oracle wire protocol

Junior Supporter

Re: TPT ODBC

Hi.

 

Can you check if you have ODBC connection with this driver and the actual DSN configuration (using some other app)?

 

Cheers.

 

Carlos.

Teradata Employee

Re: TPT ODBC

I was able to connect to the source by changing the parameters.

 

Thank you.

Re: TPT ODBC

Hi saikb26,

 

Could you please tell ,what parameters to change.

 

Am also getting similar error:

 

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 Second(s)'