All Forums Connectivity
altriadba 8 posts Joined 06/10
06 Jan 2015
AIX 6.1; Teradata ODBC 14.10; adhoc throws "79 Socket error"

 

$ /opt/teradata/client/14.10/odbc_32/samples/C/adhoc

 

Enter Data Source Name: tddev

Enter UserID: a_gilliee

Enter Password:

 

Connecting with SQLConnect(DSN=tddev,UID=a_gilliee,PWD=*)...

 

adhoc: (SQL Diagnostics) STATE=HYT00, CODE=78, MSG=[Teradata][Unix system error]  78 Socket error - No response received when attempting to connect to the Teradata server

 

ODBC connection closed.

 
Here is the  Data Source definition:

[TDDEV]

InstallDir=/opt/teradata/client/14.10/odbc_32

TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.so

Driver=/opt/teradata/client/14.10/odbc_32/lib/ tdata.so

Description=Teradata

DBCName=10.8.47.46

 
Here is  LIBPATH

$ echo $LIBPATH

/opt/teradata/client/ODBC_32/lib:/opt/teradata/client/ 14.10/lib:/opt/teradata/client/14.10/tbuild/lib:/usr/ lib:/oracle/usa/10.2.0/lib32:/db2/db2pmutc/sqllib/lib: /opt/Progress/DataDirect/Connect_for_ODBC_61/lib

 

ip-address 10.8.47.46  is  reachable on the network:

 

 

$ ping 10.8.47.46

PING 10.8.47.46: (10.8.47.46): 56 data bytes

64 bytes from 10.8.47.46: icmp_seq=0 ttl=63 time=0 ms

 

Here are the packages.. .. .. 

 

$ lslpp -lc  | grep -i  teradata | grep -i odbc

/usr/lib/objrepos:tdodbc1410.tdodbc1410:14.10.0.6:: COMMITTED:I:Teradata ODBC Driver for AIX (ODBC 14.10.00.06):

 

$ lslpp -lc  | grep -i  teradata | grep -i  icu

/usr/lib/objrepos:tdicu1410.tdicu1410:14.10.0.0:: COMMITTED:I:Shared Common Components for Internationalization for Teradata (14.10.00.00) for IBM-AIX:

/etc/objrepos:tdicu1410.tdicu1410:14.10.0.0:: COMMITTED:I:Shared Common Components for Internationalization for Teradata (14.10.00.00) for IBM-AIX:

 

$ lslpp -lc  | grep -i  teradata | grep -i cli

/usr/lib/objrepos: TeraGSS_aix_power.TeraGSS_aix_power_14.10.02.08: 14.10.2.8::COMMITTED:I:Teradata GSS client 14.10.02.08:

/usr/lib/objrepos: TeraGSS_aix_power.TeraGSS_aix_power_14.10.03.05: 14.10.3.5::COMMITTED:I:Teradata GSS client 14.10.03.05:

/usr/lib/objrepos:cliv21410.cliv21410:14.10.0.6:: COMMITTED:I:Teradata CLIV2 Library (14.10.00.06) for IBM-AIX.:

/etc/objrepos:cliv21410.cliv21410:14.10.0.6:: COMMITTED:I:Teradata CLIV2 Library (14.10.00.06) for IBM-AIX.:

 

$ lslpp -lc  | grep -i  teradata | grep -i gss

/usr/lib/objrepos: TeraGSS_aix_power.TeraGSS_aix_power_14.10.02.08: 14.10.2.8::COMMITTED:I:Teradata GSS client 14.10.02.08:

/usr/lib/objrepos: TeraGSS_aix_power.TeraGSS_aix_power_14.10.03.05: 14.10.3.5::COMMITTED:I:Teradata GSS client 14.10.03.05:

 

Any suggestions ?
Thanks.

altriadba 8 posts Joined 06/10
06 Jan 2015

subject should be  AIX 6.1; Teradata ODBC 14.10; adhoc throws "78 Socket error"
 
Thanks.

vhari 111 posts Joined 12/08
06 Jan 2015

- Add below entries under the 'tddev' DSN.
DSNTraceEnable=Yes
DSNTraceFilePath=/tmp/dsntrace.log
- Re-run 'adhoc' and grep for LCC in dsntrace.log.  The out can show connection activity.
$ grep LCC /tmp/dsntrace.log

You must sign in to leave a comment.