I want to connect to a remote machine using BTEQ from my system (DEMO Teradata installed).The entry has been added to the hosts file , I can ping the machine using the alias . But while I try to connect through BTEQ it's giving me following error ------------------ *** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
*** Return code from CLI is: 224 *** Error: Logon failed! ------------------- Message Remedy in the message manual is "Check the DBC/1012 name."
Could some one please help me understand what does that mean (DBC/1012)?
Your BTEQ must start with .logon TDEMO/USERID,password;
It think for the TeraData demo it is .logon TDmon/dbc,dbc;
Also BTEQ will not work unless your etc host file does not contain the following entery (Directory C:\WINDOWS\SYSTEM32\DRIVERS\ETC )
# Copyright (c) 1993-1999 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 184.108.40.206 rhino.acme.com # source server # 220.127.116.11 x.acme.com # x client host
127.0.0.1 localhost 18.104.22.168 TDEMO tdemocop1
22.214.171.124 is the IP Address of your PC or the server where this server resides.