Connection open failed:
[State: 08001] [Teradata][Unix system error] 113 Socket error - The Teradata server can't currently be reached over this network
Connection open failed
If you get this error, try to ping the database IP and check port (1025). If the database and port connection is open this error will be gone.
To test database connection, use the following comand (For Obiee data source connectivity from Linux machine)
[biuser@linuxdev setup]$ nqcmd -d TeradataTestDS -u usr1 -p pwd1 -s myquery.sql > myresults.out
Teradata ODBC driver pkg. installs a connectivity test tool. By default, it can be found in,
32-bit : /opt/teradata/client/14.10/odbc_32/bin/tdxodbc -h
64-bit : /opt/teradata/client/14.10/odbc_64/bin/tdxodbc -h
Hi, I also got the same issue in my environment while testign the odbc connection for TD thru nqcmd and tdxodbc.
Then i chnage the IP address instead of HOSTNAME and tested the connection again and it got successfully connected.
DBCName = <MENTION IP ADDRESS>