Teradata SQL Assistant 13 with Teradata .Net provider

Connectivity

Teradata SQL Assistant 13 with Teradata .Net provider

During the connect, when I use cnewp.xxx.com in the Server field I get following error

SQLA Version: 13.10.0.2
Teradata.Client.Provider.TdException
[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=cnewp to an IpAddress.
at Teradata.Client.Provider.WpTcpTransport.WpResolver.FirstLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.UnknownCopLookup()
at Teradata.Client.Provider.WpTcpTransport.WpResolver.GetHost()
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

But when I do nslookup of the same cnewp.xxx.com and enter the IP Address in the Server field it connects fine.

Let me know if I am doing anything wrong in first case
5 REPLIES
Teradata Employee

Re: Teradata SQL Assistant 13 with Teradata .Net provider

What version of the .NET Data Provider for Teradata?

I suggest upgrading to .NET Data Provider for Teradata version 13.1.0.4 (TTU 13.0) or version 13.11.0.1 (TTU 13.10); download it from:

http://downloads.teradata.com/download/connectivity/dot-net-data-provider

Re: Teradata SQL Assistant 13 with Teradata .Net provider

Updated to 13.11.0.1 and it works now. Thanks so much.
N/A

Re: Teradata SQL Assistant 13 with Teradata .Net provider

Hi,

I am try to create a DSN using C# code and trying to connect to Teradata, i am getting the following error

[.Net provider for teradata][115006] could not resolve datasource ="DSNNAME" to an IPaddress.

private const string ODBC_INI_REG_PATH = "SOFTWARE\ODBC\ODBC.INI\";

        private const string ODBCINST_INI_REG_PATH = "SOFTWARE\ODBC\ODBCINST.INI\";

            var datasourcesKey = Registry.LocalMachine.CreateSubKey(ODBC_INI_REG_PATH + "ODBC Data Sources");

            if (datasourcesKey == null) throw new Exception("ODBC Registry key for datasources does not exist");

            datasourcesKey.SetValue("DSNNAME", "TERADATA");

string driverName = "Teradata";

            var driverKey = Registry.LocalMachine.CreateSubKey(ODBCINST_INI_REG_PATH + driverName);

            string driverPath = driverKey.GetValue("Driver").ToString();


var dsnKey = Registry.LocalMachine.CreateSubKey(ODBC_INI_REG_PATH + dsnName);

            if (dsnKey == null) throw new Exception("ODBC Registry key for DSN was not created");

            dsnKey.SetValue("Description", "TEST DSN FOR TERADATA");

            dsnKey.SetValue("Driver", driverPath);

            dsnKey.SetValue("LastUser", Environment.UserName);

            dsnKey.SetValue("Server", "XXX.XXX.com");

            dsnKey.SetValue("Trusted_Connection", "YES");

string user_nam = System.Environment.UserName;

  Teradata.Client.Provider.TdConnection Connection = null;

               Connection = new TdConnection("Data Source=" + DSNNAME+ ";User ID=" + user_nam + ";IntegratedSecurity=True;");

             Connection.Open();



After connection, i am getting the following error

[.Net provider for teradata][115006] could not resolve datasource ="DSNNAME" to an IPaddress.


N/A

Re: Teradata SQL Assistant 13 with Teradata .Net provider

While connecting Teradata,we are  facing some error

Following error we get

SQLA Version: 13.10.0.5

Teradata.Client.Provider.TdException: [.NET Data Provider for Teradata] [115006] Could not resolve DataSource=[PROD] to an IpAddress.

[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=PROD 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 45

i have downloaded  tdnetdp__windows_indep.14.00.00.01

After installing also it shows same error

Can somebody tell me what is exact way of installing

Senior Apprentice

Re: Teradata SQL Assistant 13 with Teradata .Net provider

Did you check if PROD is actually resolved to an ip-address?

nslookup prod or nslookup prodcop1