BTEQ Connection

Database
KM
Enthusiast

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.
2 REPLIES
Enthusiast

Re: BTEQ Connection

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 TDSERVERCOP1

Remember that BTEQ can connect to the server using the hosts file.

Let me know if you need further detail.

Bye,
TDUser
Enthusiast

Re: BTEQ Connection

Hi

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:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost
11.11.11.11 TDEMO tdemocop1

11.11.11.11 is the IP Address of your PC or the server where this server resides.