All Forums Connectivity
saspert 2 posts Joined 10/11
23 Nov 2011
Errors Installing Teradata SQL Assistant

Hi,

I am having issues installing Teradata SQL assistant on my work laptop. We have Teradata 13.10 installation package and my system has Windows XP 2002.

None of my colleagues are able to help on this issue. So, I am posting it here.

11/22/2011 11:28:54 AM
SQLA Version: 13.10.0.3
Teradata.Client.Provider.TdException
[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=[cmsprodacop1.cmssvc.local] to an IpAddress.
[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=cmsprodacop1.cmssvc.local to an IpAddress.
   at Teradata.Client.Provider.WpTcpTransport.WpHost.<Addres sList>d__0.MoveNext()
   at Teradata.Client.Provider.WpTcpTransport.Connect(Int32 timeout)
   at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
   at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout)
   at Teradata.Client.Provider.Connection.Open(UtlConnection String connectionString, UInt32 timeout)
   at Teradata.Client.Provider.ConnectionFactory.GetConnecti on(Object owningObject, UtlConnectionString connStr)
   at Teradata.Client.Provider.TdConnection.Open()
   at Teradata.SQLA.TdConnectInfo.Connect() in F:\ttu1310_efix_snap\tdcli\qman\sqla\TdConnectInfo.vb: line 44
****************************************************** *
11/22/2011 11:39:06 AM
SQLA Version: 13.10.0.3
Teradata.Client.Provider.TdException
[.NET Data Provider for Teradata] [100002] Cannot create connection within the time specified.
   at Teradata.Client.Provider.WpTcpTransport.WaitOnSockets( List`1 sockets, Stopwatch timer, Int32 timeout, Int32 lccTimeout, TdErrorCollection errors)
   at Teradata.Client.Provider.WpTcpTransport.Connect(Int32 timeout)
   at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout, String password)
   at Teradata.Client.Provider.WpSession.Open(Int32 connectionTimeout)
   at Teradata.Client.Provider.Connection.Open(UtlConnection String connectionString, UInt32 timeout)
   at Teradata.Client.Provider.ConnectionFactory.GetConnecti on(Object owningObject, UtlConnectionString connStr)
   at Teradata.Client.Provider.TdConnection.Open()
   at Teradata.SQLA.TdConnectInfo.Connect() in F:\ttu1310_efix_snap\tdcli\qman\sqla\TdConnectInfo.vb: line 44
****************************************************** *

 

Thanks,
saspert
 

NetFx 259 posts Joined 09/06
25 Nov 2011

Two different issues:

1) Did you resolve the DNS issue?

Try "nslookup cmsproda.cmssvc.local" and "nslookup cmsprodacop1.cmssvc.local"; at leaset one of the commands should reutrn an IP address.

2) Set the "Connection Timeout" in the Advanced tab of the "Connection Information" dialog box. It defaults to 20 seconds.

You must sign in to leave a comment.