Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connection probleme from HP-UX with BIG-5 Charset

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Geoffrey KRETZ <gk AT 4js.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connection probleme from HP-UX with BIG-5 Charset
  • Date: Mon, 16 Feb 2009 14:25:27 +0100

Here is the log :

-bash-3.00$ cat /tmp/freetds.log
log.c:190:Starting log file for FreeTDS 0.83.dev.20080911
on 2009-02-16 14:24:38 with debug flags 0x4fff.
iconv.c:337:tds_iconv_open(800000010002a668, hkbig5)
iconv.c:78:Using trivial iconv
iconv.c:197:local name for ISO-8859-1 is ISO-8859-1
iconv.c:197:local name for UTF-8 is UTF-8
iconv.c:197:local name for UCS-2LE is UCS-2LE
iconv.c:197:local name for UCS-2BE is (null)
iconv.c:365:setting up conversions for client charset "hkbig5"
iconv.c:367:preparing iconv for "hkbig5" <-> "UCS-2LE" conversion
iconv.c:439:tds_iconv_info_init: client charset name "" unrecognized
net.c:204:Connecting to 10.0.0.199 port 1433 (TDS version 8.0)
net.c:258:tds_open_socket: connect(2) returned "操作正在進行中"
net.c:296:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:734:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
util.c:334:tdserror(800000010000f508, 800000010002a668, 20017, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:316:looking for login token, got 0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(800000010000f508, 800000010002a668, 20002, 0)
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
mem.c:563:tds_free_all_results()


jklowden AT schemamania.org wrote:
> On Fri, Feb 13, 2009 at 04:32:54PM +0100, Geoffrey KRETZ wrote:
>
>> I get the following error when trying to connect to a SQL Server
>> database with "client charset" set to big in .conf file :
>>
>> -bash-3.00$ tsql -S seville -U f4gl -P g3n3ro4j
>> locale is "zh_TW.big5 zh_TW.big5 zh_TW.big5 zh_TW.big5 zh_TW.big5
>> zh_TW.big5"
>> locale charset is "big5"
>> Msg 20017, Level 9, State -1, Server OpenClient, Line -1
>> Unexpected EOF from the server
>>
>> For info, I got the following entries in my freetds.conf file :
>> [seville]
>> host = seville
>> port = 1433
>> tds version = 8.0
>> client charset = big5
>>
>> And on my terminal, I set LC_ALL to zh_HK.big5.
>>
>> If I use UTF-8 instead of big5, I have not problem to connect.
>>
> ...
>
>> And iconv is working :
>> iconv -f big5 -t UTF-8 file : convert with success the file
>>
>
> Hmm. You seem to be doing everything right, provided the libiconv
> you're using is the same one used by iconv(1).
>
> The first 12 or so lines of a TDSDUMP log should explain what's happening,
> if not why.
>
> HTH.
>
> --jkl
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>





Archive powered by MHonArc 2.6.24.

Top of Page