All Forums Connectivity
JoeL 312 5 posts Joined 11/11
22 Jan 2014
.Net connection using explicit IP Address

I am using the Teradata 13.10 virtual machine and I have assigned it a static IP address ( for host only access.  I am able to connect via BTEQ  - .LOGON,dbc - and with SQL Assistant.   When I try to connect via the .NET provider, I get an error saying that it cannot resolve to an IP address.
Adding an entry to my hosts file or changing DNS configuration is not an option (locked down PC's in a corporate environment). 
My code:

    class Program
        private static string server = "";
        private static string user = "dbc";
        private static string password = "dbc";

        static void Main(string[] args)
            TdConnectionStringBuilder connstr = new TdConnectionStringBuilder();
            connstr.DataSource = server;
            connstr.UserId = user;
            connstr.Password = password;
            connstr.AuthenticationMechanism = "TD2";
            connstr.DataSourceDnsEntries = 0;
            connstr.ConnectionTimeout = 0;
            TdConnection tdConn = new TdConnection();
            tdConn.ConnectionString = connstr.ConnectionString;




The exact error I get:
{"[.NET Data Provider for Teradata] [115006] Could not resolve DataSource=[] to an IpAddress.\r\n[.NET Data Provider for Teradata] [115006] Could not resolve DataSource= to an IpAddress."}
The connection string the above code yields:
Connection Timeout=0;Authentication Mechanism=TD2;User Id=dbc;Data Source=;Password=dbc;Data Source DNS Entries=0
Teradata.Client.Provider  Version 13.1.04
My best guess is that is trying to do a DNS resolution on the hostname - which my DNS server knows nothing about.  How do I get the .NET provider to connect directly to the IP address and skip name resolution?

NetFx 346 posts Joined 09/06
22 Jan 2014

You must upgrade to the .NET Data Provider version 13.11 or higher.
Refer to:

You must sign in to leave a comment.