Skip to Content
0

Problems with isql

Aug 03, 2017 at 02:31 PM

85

avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ryan Hansen
Jan 05 at 05:21 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded