AIX 6.1; Teradata ODBC 14.10; adhoc throws "79 Socket error"

Connectivity
Enthusiast

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.

2 REPLIES
Enthusiast

Re: AIX 6.1; Teradata ODBC 14.10; adhoc throws "79 Socket error"

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

Thanks.

Teradata Employee

Re: AIX 6.1; Teradata ODBC 14.10; adhoc throws "79 Socket error"

- 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