bdmhilario
asked on
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
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
Check the ini,if its have the entry.See the intercaes file in the host from where you are connectiong
-K
-K
ASKER
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
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
ASKER
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,264 0
isql -U myid -P mypw -S query=TCP,10.202.16.82,264 0
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
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,264
isql -U myid -P mypw -S query=TCP,10.202.16.82,264
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
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>
I think you should restore original interfaces file and use isql by providing the actual server name:
isql -U myid -P mypw -S <SERVERNAME>
ASKER
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,264 0
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
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,264
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for responding to my question.
ASKER
Thank you to all who responded to my question.
Please check if sql.ini is correctly set. Check if ASE server is running.