What's wrong?

[babeo]

Hi

I create a new user and try to log in with that new id, however I keep having error message and still can not log in using that new id, what did I do wrong? Here is the error message
MyServer:/opt/sybase/bin> isql -Utest -Ptesting
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

Please help
Thanks

 

[qyllr]

hello,

try running...
sp_displaylogin test
to verify whether or not you created your login successfully...

here's the syntax to add a new login...

use master
go
sp_addlogin test, testing
go

are you typing in the server name on your isql line?

it should be $SYBASE/bin/isql -Utest -Ptesting -S{serverName}

because your error says "...server name not found."

if you are typing it in... check whether or not you have an entry for the server in your interfaces file...

you can find it under $SYBASE path...

hth,
q.
hth,
q.

 

[babeo]

When I use sp_displaylogin I will see the complete info about "test" user, but you are right that I have to use the -Sservername in order to log in. However, I have another question how can I set up for isql to pick up the server name automatically? because I use exactly the same command (without indicating the server name) on another machine and I went through ?

thanks

 

[qyllr]

hello,

it is probably aliased in your other machine...
check the .profile in the unix login's home directory...

do an 'ls -al' and you will see the .profile...
vi the .profile file... and you should see something like this...

isql() {isql -Utest -Ptesting -SserverName }

if not there could be a script that you are running when you give the isql command...

here's a little shell script you can run if you do not like re-typing the isql line:


sql.sh
---------
#! /usr/bin/sh

setenv SYB_BIN /opt/sybase/system1200/OCS-12_0/bin

$SYB_BIN/isql -Utest -Ptesting -SserverName
---------

just type ./sql.sh

hth,
q.

 

[babeo]

Hi
Actually, I find out the answer. There's someone changing something in the .profile, and did not let me know, and I usually don't log out my session everyday, as the result, I get error and could not log in until I log out and log in again or I have to specify the server name in the "isql" command.

For how to get server name automate in the "isql" command (which you don't have to specify the server name) you have to make a change or add a line in the .cshrc with the following sentense:

setenv DSQUERY YourServerNameHere

or make a change or add a line in .profile as

DSQUERY=YourServerNameHere

Thanks
babeo