All Forums Connectivity
AbhinavBansal 1 post Joined 01/13
19 Feb 2013
Teradata Setup on MAC - Connection, Database etc.

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 
I followed the link for steps but I am getting an error when I try to connect to 'testServer' via JDBC connection. I have updated my local IP in /etc/hosts as a DNS name.
http://developer.teradata.com/tools/articles/teradata- studio-express 
Could someone help me setup and get the Teradata running on Mac. I would appreciate any pointers in where I am going wrong. 
~Aby
 
Error Message:
 

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.00.00.13] [Error 1000] [SQLState 08S01] Login failure for Connection to MyTD Tue Feb 19 20:52:24 PST 2013 socket orig=MyTD cid=3bf27f74 sess=0 java.net.ConnectException: Connection refused  at java.net.PlainSocketImpl.socketConnect(Native Method)  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.jav a:351)  at java.net.PlainSocketImpl.connectToAddress(PlainSocketI mpl.java:213)  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java: 200)  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java: 432)  at java.net.Socket.connect(Socket.java:529)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThrea d.run(TDNetworkIOIF.java:968) 

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

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

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

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

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

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

at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.jav a:586)

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

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

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

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct Connection(JDK6ConnectionFactory.java:22)

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

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

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

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

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

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

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:73)

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.ConnectException: Connection refused

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

at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.jav a:351)

at java.net.PlainSocketImpl.connectToAddress(PlainSocketI mpl.java:213)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java: 200)

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

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

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

 

~ Abhinav
You must sign in to leave a comment.