Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   MTDP: EM_NOHOST(224) error
 
From:   zqi

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016