Skip to Content
avatar image
Former Member

Problems with isql

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 05 at 05:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded