All Forums Connectivity
sargofco72 2 posts Joined 06/16
02 Aug 2016
Unable to Connect to Teradata Database from Teradata Studio on iOS (Mac)

Hello Guys, I am to attempt to connect to a remote TERADATA Database from the Teradata Studio from my Mac. The error reported is showed below and this same error happened from the Linux Operating System. But if I configure a DNS in Windows I can connect to the Remote Teradata when the connection testing is executed.
Please Forum, can you help me ?? I have checked the older post regarding this issue buy any help me to solve the situation.
 

java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.10.00.15] [Error 1277] [SQLState 08S01] Login timeout for Connection to ICW_Iberia Tue Aug 02 10:37:06 CEST 2016 socket orig=ICW_Iberia cid=46a9759f sess=0 java.net.SocketTimeoutException: connect timed out  at java.net.PlainSocketImpl.socketConnect(Native Method)  at java.net.AbstractPlainSocketImpl.doConnect(AbstractPla inSocketImpl.java:350)  at java.net.AbstractPlainSocketImpl.connectToAddress(Abst ractPlainSocketImpl.java:206)  at java.net.AbstractPlainSocketImpl.connect(AbstractPlain SocketImpl.java:188)  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java: 392)  at java.net.Socket.connect(Socket.java:589)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThrea d.run(TDNetworkIOIF.java:1224) 

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:94)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:69)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCE xception(ErrorFactory.java:207)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoE rror(ErrorAnalyzer.java:59)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocket Connection(TDNetworkIOIF.java:158)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNet workIOIF.java:137)

at com.teradata.jdbc.jdbc.GenericTeradataConnection.getIO (GenericTeradataConnection.java:130)

at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:98)

at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:208)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6 _SQL_Connection.java:35)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct SQLConnection(JDK6ConnectionFactory.java:25)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:179)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:169)

at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :234)

at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java: 160)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.makeConnection(TeradataJDBCConnec tion.java:278)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.createConnection(TeradataJDBCConn ection.java:123)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection(DriverConnectionBase.java: 105)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.open(JDBCConnection.java:96)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataPingFactory.createConnection(TeradataPingFactory .java:36)

at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv ider.java:83)

at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(PingJob.java:76)

at org.eclipse.datatools.connectivity.ui.PingJob.run(Ping Job.java:59)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java: 54)

Caused by: java.net.SocketTimeoutException: connect timed out

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPla inSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(Abst ractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlain SocketImpl.java:188)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java: 392)

at java.net.Socket.connect(Socket.java:589)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThrea d.run(TDNetworkIOIF.java:1224)

 

Fred 1096 posts Joined 08/04
03 Aug 2016

Can you "ping" ICW_Iberiacop1? What does your connection string look like? (Just in general, mask any sensitive info.)

sargofco72 2 posts Joined 06/16
04 Aug 2016

Hello Fred, thank for your help. If I ping this name (this is the name that I set in the hosts file associating with a IP of the Teradata Server) and ping directly the IP, I don't have response but the IT Guys tell me that is normal. They tell me that I have to use the ODBC to connect to the server, the problem is that if I set a ODBC connection using Windows OS I can connect but using Linux or Unix I can't .... and I had check all that I think should be set. 

You must sign in to leave a comment.