Skip to Content.
Sympa Menu

freetds - RE: [freetds] problems connecting to Sybase with tsql 8.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "David Leith" <david.leith AT uptimesoftware.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: RE: [freetds] problems connecting to Sybase with tsql 8.0
  • Date: Thu, 23 Jun 2005 14:23:16 +0100

You seem to be using TDS version 8.0 to talk to Sybase - a big bad , I'm
afraid.
You should always use TDS 5.0 to talk to Sybase databases, TDS 7.0 or
8.0 to talk to MS SQL 2000

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of David Leith
Sent: 23 June 2005 14:05
To: freetds AT lists.ibiblio.org
Subject: [freetds] problems connecting to Sybase with tsql 8.0


We are having a problem connecting to Sybase versions 12.0 since moving
to
tsql 8.0 from 5.0. Here is an example:

Working.....
# ./tsql.5 -C
locale is "C"
locale charset is "646"
Compile-time settings (established with the "configure" script):
Version: freetds v0.62.3
MS db-lib source compatibility: no
Sybase binary compatibility: unknown
Thread safety: no
iconv library: yes
TDS version: 5.0
iODBC: no
unixodbc: no
# ./tsql.5 -Hcbs4 -p4025 -Ucbs -P???? <
/usr/local/bin/select_offline_programs.sql
locale is "C"
locale charset is "646"
Msg 2409, Level 11, State 2, Server cbs4, Line 1
Cannot find the requested character set in Syscharsets: name = 'iso646'.


Msg 2411, Level 10, State 1, Server cbs4, Line 1
No conversions will be done.

1> 2> 3> 4> 5> 6> 7> 8> 9> (return status = 0)

OK - no offline program detected
1> #

Now working.....
# ./tsql.8 -C
locale is "C"
locale charset is "646"
Compile-time settings (established with the "configure" script):
Version: freetds v0.62.4
MS db-lib source compatibility: no
Sybase binary compatibility: unknown
Thread safety: no
iconv library: yes
TDS version: 8.0
iODBC: no
unixodbc: no
# ./tsql -Hcbs4 -p4025 -Ucbs -P????? <
/usr/local/bin/select_offline_programs.sql
locale is "C"
locale charset is "646"
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
#

Not sure what the difference is but we have been unable to get this
previously working script to run with the newer tsql. Connecting using
the
new version results in these messages on the server:

01:00000:00126:2005/06/20 17:16:11.22 server Error: 1621, Severity: 18,
State: 1
01:00000:00126:2005/06/20 17:16:11.22 server Type '' not allowed before
login.

Any help is appreciated. We have found that running without the script
and
just trying to login produces the same errors.

...David Leith
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------




Archive powered by MHonArc 2.6.24.

Top of Page