Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "David Leith" <david.leith AT uptimesoftware.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] problems connecting to Sybase with tsql 8.0
  • Date: Thu, 23 Jun 2005 09:05:08 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page