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 this:xxx.xxx.xxx.xxx(ip 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:## 102.54.94.97 rhino.acme.com # source server# 38.25.63.10 x.acme.com # 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.

Regards
Divvy

You must sign in to leave a comment.