Errors Installing Teradata SQL Assistant

Connectivity

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.<AddressList>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(UtlConnectionString connectionString, UInt32 timeout)

   at Teradata.Client.Provider.ConnectionFactory.GetConnection(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(UtlConnectionString connectionString, UInt32 timeout)

   at Teradata.Client.Provider.ConnectionFactory.GetConnection(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

Tags (1)
1 REPLY
Teradata Employee

Re: Errors Installing Teradata SQL Assistant

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.