Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2009
    Location
    Calgary, AB Canada
    Posts
    38

    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):

    use master
    go
    create login testuser with password abc123 default database master
    go
    sp_adduser testuser
    go
    grant all to testuser
    go

    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:
    Login failed.
    CT-LIBRARY error:
    ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

    My entry in the interfaces file is:
    LOCALHOST
    master tcp ether localhost 5000
    query tcp ether localhost 5000

    What am I missing?

  2. #2
    Join Date
    Dec 2013
    Posts
    14
    I am not certain, but try it without space.

    isql64 -Utestuser -Pabc123 -SLOCALHOST

    Also, look into sqsh(It is sooo much better than isql).

  3. #3
    Join Date
    Sep 2014
    Posts
    4

    isql64 connection

    U can Use
    isql64 -S[server name] -U[user name] -P[password]

    for encryption
    isql64 -S[server name] -U[user name] -P[password] -X

  4. #4
    Join Date
    Sep 2014
    Posts
    4

    command for isql and isql64

    For encryption-
    isql64 –S[sever name] –U[user name] –P[Password] –X

    isql –S[sever name] –U[user name] –P[Password] -X

    for Non-Encryption-

    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 02:45. Reason: need to add some more information

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •