Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Server version and TDS Version

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Vinh Nguyen <vinhdizzo AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server version and TDS Version
  • Date: Sun, 16 May 2010 12:47:41 -0700

On Mon, May 3, 2010 at 2:37 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> Il giorno ven, 30/04/2010 alle 16.30 -0400, jklowden AT schemamania.org ha
> scritto:
>> On Fri, Apr 30, 2010 at 02:58:12PM -0400, jklowden AT schemamania.org wrote:
>> >
>> > 1.  API call e.g. DBSETLCHARSET().
>> > 2.  freetds.conf.
>> > 3.  nl_langinfo(3) /* query using CODESET parameter */
>> > 4.  setlocale(3) /* query using NULL parameter, split on "." */
>> > 5.  ISO 8859-1
>> >
>> > None of this works today, as you know.
>>
>> It works even less now.  I committed changes to tds_alloc_locale()
>> to get its initial values as I described.  glibc give a free backtrace
>> error.  I'm sure it's right, but I've run out of time.
>>
>
> strdup man, strdup !! :)
>
> I think I fixed the problem yesterday...

bsqldb and isql both works for me for v8.0. However, tsql does not:

$ TDSDUMP=stderr TDSVER=8.0 tsql -S adrc -U USERNAME -P PASSWORD
locale is "en_US.utf-8"
locale charset is "utf-8"
log.c:196:Starting log file for FreeTDS 0.83.dev.20100504
on 2010-05-16 12:42:50 with debug flags 0x4fff.
iconv.c:337:tds_iconv_open(0x1001007b0, utf-8)
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 UCS-2BE
iconv.c:365:setting up conversions for client charset "utf-8"
iconv.c:367:preparing iconv for "utf-8" <-> "UCS-2LE" conversion
iconv.c:443:tds_iconv_info_init: client charset name "" unrecognized
net.c:221:Connecting to 128.200.55.20 port 1433 (TDS version 7.1)
net.c:277:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:317:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
net.c:788:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(..�...|
0020 55 00 00 02 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 0f 6b 00 00 - |.k..|

net.c:604:Received header
0000 04 01 00 25 00 00 01 00- |...%....|

net.c:658:Received packet
0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 09 00 0f |........ ....�...|
0020 d5 00 00 02 00 - |�....|

login.c:1044:detected flag 2
login.c:771:quietly sending TDS 7+ login packet
token.c:328:tds_process_login_tokens()
util.c:337:tdserror(0x1001001d0, 0x1001007b0, 20017, 0)
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
util.c:367:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:390:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from IDLE to DEAD
token.c:337:looking for login token, got 0()
token.c:122:tds_process_default_tokens() marker is 0()
token.c:125:leaving tds_process_default_tokens() connection dead
login.c:462:login packet accepted
util.c:337:tdserror(0x1001001d0, 0x1001007b0, 20002, 0)
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
util.c:367:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:390:tdserror: returning TDS_INT_CANCEL(2)
mem.c:615:tds_free_all_results()
There was a problem connecting to the server

My main goal was getting isql to work (and now it does), this suffices
for me. However, since u guys are getting so close to getting all
this to work, I'm willing to help debug and getting this resolved.

Many thanks!
Vinh




Archive powered by MHonArc 2.6.24.

Top of Page