|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/10/2008 10:17:21 PM
Posts: 3,
Visits: 11
|
|
Hi everyone:
I downloaded teradata, configured everything, did a small application with C%.NET and successfully connected to a database I created. However I cant logon with BTEQ, using the same password. I looked online for instructions, I did everything I read but nothing...
I tried this:
--------------------------------------------------------------
Copyright 1984-2007, NCR Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon
.logon
UserId:
user1
Password:
******
*** CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.
*** Return code from CLI is: 224
*** Error: Logon failed!
*** Total elapsed time was 23 seconds.
Teradata BTEQ 12.00.00.01 for WIN32. Enter your logon or BTEQ command:
-------------------------------------------------
but nothing, I tried several other things but nothing either... what could I be doing wrong?
(the server is started as I can access data by a .NET application)
Thank you
LD
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/10/2008 10:17:21 PM
Posts: 3,
Visits: 11
|
|
by the way, I tried with that user that I have created and I tried with other built in users, the response is always the same...
Anyway, is there any built in default user like the oracle "scott/tiger"?
Any help is welcome
Thank you very much
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/10/2008 10:17:21 PM
Posts: 3,
Visits: 11
|
|
Its solved... sorry...
just tried .logon 127.0.0.1/user1 then password and the miracle happend... I guess you can really can loose time with silly problems...
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 6:49:01 AM
Posts: 180,
Visits: 578
|
|
Hello,
You need to add user's entry in hosts file. You can follow these steps to do so:
- Open "C:\WINDOWS\system32\drivers\etc\hosts" file in any text editor (Notepad etc.)
- Add this new line in it "127.0.0.1 localhost cop1" e.g. for DBC user it will be "127.0.0.1 localhost dbccop1" (take backup of the hosts file before changing it)
- Save the hosts file
- Open BTEQ, and use following command (suppose we have dbc username with dbc password) to login:
- ".LOGON dbc" press enter
- Enter password "dbc" press enter
And you should be in. :)
HTH.
Regards,
Adeel
|
|
|
|