Date:         Tue, 10 Jul 2007 11:24:12 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Strange SAS teradata message

I have no teradata, but I have an idea, where to look. That name, you use,
is not the real name. Means: behind EM_NOHOST there is something other.
For IP-adresses in TCP/IP there is a file where that substitutions are
contained. For the big WWW that is done by DNS servers, for some local
names, you have the HOSTS file. Maybe the substitute is also something
like a IP-adress.
You should contact your sysadmin with that error message. He can tell you,
how the name is, you can use, or he enters the needed entry in the right
file, so you can use the name you are used to.
Gerhard



On Tue, 10 Jul 2007 08:02:56 -0700, ssegall@GMAIL.COM wrote:

>All,
>Not really sure if that many people in here define Libraries in
>Teradata using SAS, but I'd figure I'd give it a shot.  May be an
>error that shows up using other more popular databases.
>
>I am using the following script that I have always used to define the
>libname statement.
>
> libname XXXXX teradata server=XXXXXXX user=XXXXXX password=XXXXXXXX
>schema=XXXXX;
>
>When I entered this I get the following error.
>
>ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS
>file or names database.  .
>ERROR: Error in the LIBNAME statement.
>
>I have no clue what this means.
>
>I have run the same exact script on my laptop and was able to
>sucessfully connect.  Unfortunately running SAS on my laptop isn't a
>good solution.  Any ideas what the error means or how I might resolve
>it.
>
>Thanks,
>-Steven Segall