Problems with isql

[Former Member]

In windows, the environment variables, including SYBASE HOME, are located in the following files:


SYBASE.bat

SYBASE.ini


These files are located in HOME.

Now it says there
Set SYBASE = C: \ isql


Now home for isql and for bases does not match and when I try to connect to the database via isql I get the following error:

     CT-LIBRARY error:,
     ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.


Help please, how to achieve connection through isql?

[ryan_hansen]

Hi,

Here are the steps:
1. open cmd prompt

2. Go to your sybase install
cd %SYBASE%
3. set environment variables

SYBASE.bat

4. isql -Usa -Sasename
isql -Usa -Spvrh

or

isql -Usa -Sasehost:aseport
isql -Usa -Sjuniper:1234

If you want to use the asename you need to update the %SYBASE%\ini\sql.ini file

Example:
[pvrh]
master=tcp,juniper,1234
query=tcp,juniper,1234

Regards,
Ryan