All Forums Database
KM 5 posts Joined 02/06
17 Feb 2006
BTEQ Connection

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 inputs will be highly appreciated.

TDUser-781 35 posts Joined 12/04
17 Feb 2006

Hi KM,when you log on via bteq, you have stg like this:.logon /,;suppose that your server's name is TDSERVER, you need to:1. write in the bteq file: .LOGON TDSERVER/,2. have in you hosts file an entry like address of the server) TDSERVER TDSERVERCOP1Remember that BTEQ can connect to the server using the hosts file.Let me know if you need further detail.Bye,TDUser

XTUPIE 42 posts Joined 11/05
23 Feb 2006

HiYour 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:## # source server# # x client host127.0.0.1 localhost11.11.11.11 TDEMO tdemocop111.11.11.11 is the IP Address of your PC or the server where this server resides.


You must sign in to leave a comment.