Unable to connect to Sybase instance using iSQL.

Greetings All,

I am trying to connect to the Sybase database instance but I am unable to connect isql to Sybase database instance due to the following error:

CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: : There was an error encountered while binding to the directory service
bdmhilarioAsked:
Who is Participating?
 
alpmoonConnect With a Mentor Commented:
My comment was based on the message you got at your last post before mine:

"Invalid syntax found in interfaces file."

In your previous post the message was "Requested server name not found."

So it looks the files were different.

You can try dscp to check interfaces file:

$ dscp
>> open
ok
Session 1 InterfacesDriver>> list

Server objects found:
    XXXX
    XXXX_BS
0
 
Som TripathiDatabase AdministratorCommented:
This error is most common error in case of connection failure.
Please check if sql.ini is correctly set. Check if ASE server is running.
0
 
KodukullaCommented:
Check the ini,if its have the entry.See the intercaes file in the host from where you are connectiong

-K
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
bdmhilarioAuthor Commented:
All,

The Sybase instance I am working with is running on the Linux server.  And yes, the Sybase intance is running.  I receive this error message when I try to use Sybase isql on the Linux server.

When I submit the command:
isql -U myid -P mypw

I receive the following error message:
CT-LIBRARY error:
        ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

Any ideas are greatly appreciated.

Thank you.
BDMHILARIO
0
 
bdmhilarioAuthor Commented:
All,

I just tried the following and it still does not work.  I am providing more information about the interfaces file entries.

[SERVERNAME]
query=TCP,10.202.16.82,2640

isql -U myid -P mypw -S query=TCP,10.202.16.82,2640

I am still getting the following error msg:
CT-LIBRARY error:
        ct_connect(): directory service layer: internal directory control layer error: Invalid syntax found in interfaces file.

Another question I have is there another Sybase configuration file, ie RUN_server file,  I need to check/use?

Any help is greatly appreciated.

Thank you.
BDMHilario
0
 
alpmoonCommented:
That format is for Windows sql.ini file. Interfaces file format on UNIX/Linux platforms is different. You shouldn't edit interfaces file directly. You can use dscp to edit it.

I think you should restore original interfaces file and use isql by providing the actual server name:

isql -U myid -P mypw -S <SERVERNAME>  

0
 
bdmhilarioAuthor Commented:
Alpmoon,

Thank you for the response.
The interfaces file I displayed in my previous comment is on the Linux server in the directory:
/opt/SYBASE

-rw-r--r--  1 root   root     41 Nov  3 06:32 interfaces

INTERFACES FILE
---------------------
[SERVERNAME]
query=TCP,10.202.16.82,2640

I did not create this file as I am just started working with this company.
So, you are saying I should change the interfaces to use a different format?

Let me know.
Thanks.
bdmhilario
0
 
bdmhilarioAuthor Commented:
Thank you for responding to my question.
0
 
bdmhilarioAuthor Commented:
Thank you to all who responded to my question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.