Re: Sybase Client, issues with isql

On Nov 23, 7:29 pm, Keith <keith.wing...@xxxxxxxxxxxxxxxxx> wrote:
On Nov 22, 12:57 am, Rajesh <raj...@xxxxxxxxxxxxxxxxxxxx> wrote:



Hi,
I am trying to establish a connection from windows with sybase server
located on unix. I have created a Server Name Entry using DSEDIT. The
name being SDESK. I pinged the server from the DSEDIT utility and it
worked.

How do I login to the database now ? I use the isql command as given
below.
isql -Uxxx -Pxxx -SSDESK

But I am getting the error

CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: There
is a tds protocol error. An illegal token was received.

I am having a problem now to know what is the way to connect to
sybase. Need I create a DSN for this ? I see a driver "Sybase ASE ODBC
Driver" in the ODBC administrator. Is that the one I should use ?

Please help.

Regards,
Rajesh

In the DOS (cmd, or command) window you ran this from, is %SYBASE%
set. (The SET command will show you).

Is there a SQL.INI in that directory, er, uh, folder, and is it
correct? (NOTEPAD.EXE or "type" the file....).

Are you sure the ISQL.EXE you're running is the one for the correct
Sybase client and not the one for e.g. MS SQL-Server, Informix, ...?

(There's no "which" or "whence" AFAIK in DOS, so you'll have to try to
call the thing w/ an absolute PATH to be sure).

Keith


Keith,
Thanks for the reply. When I do SET %SYBASE% in DOS, I get the
following message.
Environment Variable c:\sybase not defined.
.

Relevant Pages

  • Re: Sybase Client, issues with isql
    ... I am trying to establish a connection from windows with sybase server ... located on unix. ... I have created a Server Name Entry using DSEDIT. ...
    (comp.databases.sybase)
  • Get Segmentation Fault when Building Sybase
    ... When trying to install sybase 15 on fedora core 8 get the following ... Building Adaptive Server 'LOCALHOST': ... Specify a configuration file name in the RUNSERVER file to avoid this ... No external security mechanisms will be supported. ...
    (comp.databases.sybase)
  • Re: Sybase Client, issues with isql
    ... I am trying to establish a connection from windows with sybase server ... located on unix. ... I have created a Server Name Entry using DSEDIT. ...
    (comp.databases.sybase)
  • Re: DBD::Sybase question
    ... You can interact with an ASE 15 server with a 12.5.1 client with no ... interface with all sorts of Sybase servers (including an antique 4.9.2 ... Toute utilisation de ce ...
    (perl.dbi.users)
  • Re: Sybase Client, issues with isql
    ... I am trying to establish a connection from windows with sybase server ... I have created a Server Name Entry using DSEDIT. ...
    (comp.databases.sybase)