FreeTDS Development Group

[Luciano Pacheco <lucmult AT gmail.com>]

Hi,

I'm trying connect from Mac OSX Leopard with FreeTDS to a MSSQL 2000 MSDE,
and I'm getting this error:

[01:40:09] $ /usr/local/bin/tsql  -S MACLUCK -I
/opt/local/etc/freetds/freetds.conf  -U lucianopacheco -D dbServicos  -P
lerolero
locale is "pt_BR.utf-8"
locale charset is "utf-8"
Default database being set to dbServicos
Msg 20017, Level 9, State -1, Server OpenClient, Line -1
Unexpected EOF from the server
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed

I also tried with (and got the same error):
[01:47:15] $ /usr/local/bin/tsql  -H 172.16.182.128 -p 1433 -U
lucianopacheco -P lerolero

My freetds.conf:
[MACLUCK]
    host = 172.16.182.128
    port = 1433
    tds version = 7.0
    database = dbServicos

I also tried with tds version = 8.0 and get the same error.

Log:
01:45:08.188745 76313 (log.c:196):Starting log file for FreeTDS
0.83.dev.20100122
on 2010-05-07 01:45:08 with debug flags 0xffff.
01:45:08.193574 76313 (iconv.c:336):tds_iconv_open(0x100200820, utf-8)
01:45:08.194161 76313 (iconv.c:197):local name for ISO-8859-1 is ISO-8859-1
01:45:08.194179 76313 (iconv.c:197):local name for UTF-8 is UTF-8
01:45:08.194188 76313 (iconv.c:197):local name for UCS-2LE is UCS-2LE
01:45:08.194197 76313 (iconv.c:197):local name for UCS-2BE is UCS-2BE
01:45:08.194206 76313 (iconv.c:364):setting up conversions for client
charset "utf-8"
01:45:08.194215 76313 (iconv.c:366):preparing iconv for "utf-8" <->
"UCS-2LE" conversion
01:45:08.194237 76313 (iconv.c:442):tds_iconv_info_init: client charset name
"" unrecognized
01:45:08.194269 76313 (net.c:221):Connecting to 172.16.182.128 port 1433
(TDS version 7.1)
01:45:08.194423 76313 (net.c:277):tds_open_socket: connect(2) returned
"Operation now in progress"
01:45:08.195014 76313 (net.c:317):tds_open_socket() succeeded
01:45:08.195034 76313 (util.c:162):Changed query state from DEAD to IDLE
01:45:08.195086 76313 (net.c:786):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 19 2a 01 00            -                        |.*..|

01:45:08.196894 76313 (net.c:605):Received header
0000 04 01 00 25 00 00 01 00-                        |...%....|

01:45:08.196949 76313 (net.c:659):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 08 00 07 |........ ....?...|
0020 f7 00 00 02 00         -                        |?....|

01:45:08.196977 76313 (login.c:1040):detected flag 2
01:45:08.196988 76313 (login.c:767):quietly sending TDS 7+ login packet
01:45:08.197028 76313 (token.c:315):tds_process_login_tokens()
01:45:08.201956 76313 (util.c:337):tdserror(0x1002001e0, 0x100200820, 20017,
0)
01:45:08.202106 76313 (util.c:367):tdserror: client library returned
TDS_INT_CANCEL(2)
01:45:08.202121 76313 (util.c:396):tdserror: returning TDS_INT_CANCEL(2)
01:45:08.202151 76313 (util.c:162):Changed query state from IDLE to DEAD
01:45:08.202173 76313 (token.c:319):looking for login token, got  0()
01:45:08.202187 76313 (token.c:111):tds_process_default_tokens() marker is
0()
01:45:08.202197 76313 (token.c:114):leaving tds_process_default_tokens()
connection dead
01:45:08.202207 76313 (login.c:467):login packet accepted
01:45:08.202216 76313 (util.c:337):tdserror(0x1002001e0, 0x100200820, 20002,
0)
01:45:08.202231 76313 (util.c:367):tdserror: client library returned
TDS_INT_CANCEL(2)
01:45:08.202240 76313 (util.c:396):tdserror: returning TDS_INT_CANCEL(2)
01:45:08.202250 76313 (mem.c:603):tds_free_all_results()

How can I use the option "-o" of tsql ?

What else can I try ?

Thanks,
-- 
Luciano Pacheco
blog.lucmult.com.br