Archives of the TeradataForum

Message Posted: Tue, 07 Aug 2007 @ 20:58:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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] [224]
            MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

     ** DbException caught ***

My program uses Teradata .Net Data Provider 1.2.0.0 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.

John

	<Prev	Next>		<<First	<Prev	Next>	Last>>