var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: issues logging into ASE15.7 using isql64
I'm new to Sybase and I'm trying to setup a general, vanilla instance. I have successfully created the instance, and am able to log into the LOCALHOST server with 'sa'.
I'm now trying to create and log in with a different userid and I'm running into problems. This is a Red Hat 5 installation. Here is my workflow (as sa):
create login testuser with password abc123 default database master
grant all to testuser
Now I would assume this is all I would need, but when I run isql64:
isql64 -U testuser -P abc123 -S LOCALHOST
I get the standard:
Msg 4002, Level 14, State 1:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
My entry in the interfaces file is:
master tcp ether localhost 5000
query tcp ether localhost 5000
What am I missing?
I am not certain, but try it without space.
isql64 -Utestuser -Pabc123 -SLOCALHOST
Also, look into sqsh(It is sooo much better than isql).
U can Use
isql64 -S[server name] -U[user name] -P[password]
isql64 -S[server name] -U[user name] -P[password] -X
command for isql and isql64
isql64 –S[sever name] –U[user name] –P[Password] –X
isql –S[sever name] –U[user name] –P[Password] -X
isql64 –S[sever name] –U[user name] –P[Password]
isql –S[sever name] –U[user name] –P[Password]
Last edited by navin Tiwary; 09-11-14 at 01:45.
Reason: need to add some more information