Sybase, connecting with Isql failed but not from Interactive sql

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>


motioneyeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

razorBladesCommented:
try removing the port number from the command.

isql -SKTRW2004 -UKRY12

let me know if it works!
0
arun401Commented:
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
IncisiveOneCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
motioneyeAuthor Commented:
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
IncisiveOneCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.