?
Solved

Sybase, connecting with Isql failed but not from Interactive sql

Posted on 2009-07-05
5
Medium Priority
?
1,759 Views
Last Modified: 2012-05-07
I'm trying to connect to sybase from Isql and it keep returned me error below: But this will not be the case when connected using Interactive SQL or Sybase central, any hints ?


C:\sybase\OCS-15_0\bin>isql -SKTRW2004,5000 -UKRY12
Password:
CT-LIBRARY error:
        ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

C:\sybase\OCS-15_0\bin>


0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 

Expert Comment

by:razorBlades
ID: 24783204
try removing the port number from the command.

isql -SKTRW2004 -UKRY12

let me know if it works!
0
 
LVL 1

Expert Comment

by:arun401
ID: 24783609
Remove the port number in the system number.

Still if it is not working .Check the interface file in your Unix machine.
the interfaces file provides UNIX clients and servers connectivity information about a Sybase server.

It provides two main functions, from the server point of view it provides the means to start network listeners upon server boot, if it can't resolve the information in the interfaces file the server will fail to start. As far as the client is concerned the file provides client programs, isql, bcp etc. with connection information to the server.
Please go through the below link for step to step process.
http://www.outlands.demon.co.uk/sybase/index.html
Let me know if any information required.
Thanks Arun P
0
 
LVL 6

Accepted Solution

by:
IncisiveOne earned 2000 total points
ID: 24789324
arun401

The interfaces file (actually, sql.ini, since he is on Windoze) has nothing to do with it.  If sql.ini was incorrect, Interactive SQL would not be able to connect.

motioneye

You need the Utility Reference Manual for isql.  There are many helpful options in addition to -S and -U, not to mention the arguments expected for -S and -U.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.blocks/html/blocks/blocks184.htm

Cheers

0
 

Author Comment

by:motioneye
ID: 24791425
Still not able to logon, buit giving me different error msgs.

C:\sybase\OCS-15_0\bin>isql -SKTRW2004 -UKRY12
Password:
CT-LIBRARY error:
        ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed
.

C:\sybase\OCS-15_0\bin>
0
 
LVL 6

Assisted Solution

by:IncisiveOne
IncisiveOne earned 2000 total points
ID: 24793099
That error usually means the login of password was incorrect.  Can you confirm (from your successful Interactive SQL connetion) that your have:
- Interactive SQL connetion running from the same directory (confirms your sql.ini file is accessible from there, and it is valid)
- an ASE server called KTRW2004
- a vliad unlocked login KRY12
- you entered the correct password for KRY12

Cheers

0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introducing Priority Question, our latest feature.
Hey fellow admins! This time, I have a little fairy tale for you. As many tales do, it starts boring and then gets pretty gory. I hope you like it. TL;DR: It is about an important security matter, you should read it if you run or administer Windows …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month10 days, 16 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question