Archives of the TeradataForum
Message Posted: Tue, 07 Aug 2007 @ 20:58:13 GMT
I have a Visual Studio 2005 program running on Windows 2000 Server trying to connect to our Teradata servers but got the error below:
[Call-Level Interface, Version 2]  MTDP: EM_NOHOST(224): name not in HOSTS file or names database. ** DbException caught ***
My program uses Teradata .Net Data Provider 18.104.22.168 to connect to TD servers. Connection string like below:
sConn = "Data Source=" + source + ";User ID=" + username + ";Password=" + password;
Code to connect like below:
DbProviderFactory pf = DbProviderFactories.GetFactory("Teradata.Client.Provider"); DbConnection con = pf.CreateConnection(); con.ConnectionString = sConn; con.Open();
Our server names are:
td1cop1.biz.mycompany.com td2cop1.mycompany.com (naming convention different from the one above)
What should I put in to the HOSTS file to get over this error msg? The full server names, or just the td1cop1/td2cop1, or just td1/td2, or the physical IPs? And how? I'm pretty foreign to the HOSTS file editing and really not sure what went wrong. The same thing works on XP environments but not these Win2K Servers.
Any suggestions/advices will be greatly appreciated.
Thanks very much.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|