Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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 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 =
     DbConnection con = pf.CreateConnection();
     con.ConnectionString = sConn;

Our server names are:

     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.


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023