Connecting isql

[#1]

Hello,

I´m trying to connect to Sybase Database via isql for to unlock the user "sa" and update the Sybase DB.

I´ve been following the thread http://scn.sap.com/thread/3268654, but I couldn´t connect.

D:\sybase\PRD>isql -U sapsso -S name_server

Which is the "standard" way to connect or the correct sentence?

Thanks a lot

[ryan_hansen · Accepted solution]

Hi Ruben,

As Suresh mentioned it will be very helpful to know what kind of error you are running into.

Common issues would be:

1. setting environment variables before executing isql.

example-

Open a cmd prompt.

Go to your root SYBASE directory

Execute the bat file that holds environment variables.

SYBASE.bat

Then run your isql command:

isql -Usa -P<password> -S<asehost>:<aseport>

isql -Usa -Psybase -S10.172.104.105:5000

or

isql -Usa -P<password> -S<sql.ini entry>

isql -Usa -Psybase -SASE157

sql.ini entries are found in:
%SYBASE%\ini\sql.ini

2. Server is down

3. Port number is incorrect

4. DSN isn't being resolved you can test IP address instead.

Regards,

Ryan

[Former Member]

Hi

For logging into sybase the following is the format

>isql -Uuserid -Ppassword -S SID

In your case please check your sybase server is up and running.

Please post the erorr message you are getting if you say you know the correct password.

Regards,

Suresh Daniel.