FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2013/6/25 arielCo <arielco AT gmail.com>

> Same result. The only difference is that it doesn't take as long to fail:
>
> $ TDSDUMP=/tmp/ftds.dump ~/freetds/bin/fisql -H 10.192.139.22 -U ariel
> -P password
> FreeTDS: db-lib: exiting because client error handler returned
> INT_EXIT for msgno 20009
>
> $ cat /tmp/ftds.dump
> log.c:194:Starting log file for FreeTDS 0.92.dev.20130625
>         on 2013-06-25 17:39:20 with debug flags 0x4fff.
> config.c:721:Setting 'dump_file' to '/tmp/ftds.dump' from $TDSDUMP.
> iconv.c:332:tds_iconv_open(2c120, ISO8859-1)
> iconv.c:189:local name for ISO-8859-1 is ISO-8859-1
> iconv.c:189:local name for UTF-8 is UTF-8
> iconv.c:189:local name for UCS-2LE is UCS-2LE
> iconv.c:189:local name for UCS-2BE is UCS-2BE
> iconv.c:351:setting up conversions for client charset "ISO8859-1"
> iconv.c:353:preparing iconv for "ISO8859-1" <-> "UCS-2LE" conversion
> iconv.c:393:preparing iconv for "ISO-8859-1" <-> "ISO-8859-1" conversion
> iconv.c:396:tds_iconv_open: done
> net.c:228:Connecting to 192.138.151.209 port 4000 (TDS version 5.0)
> net.c:300:tds_open_socket: connect(2) returned "Operation now in progress"
> net.c:335:getsockopt(2) reported: Connection refused
> net.c:345:tds_open_socket() failed
> util.c:315:tdserror(26b20, 2c120, 20009, 146)
> dblib.c:7881:dbperror(2b9b8, 20009, 146)
> dblib.c:7934:20009: "Unable to connect: Adaptive Server is unavailable
> or does not exist"
> dblib.c:4858:dbdead(2b9b8) [dead]
> dblib.c:7955:"Unable to connect: Adaptive Server is unavailable or
> does not exist", client returns 0 (INT_EXIT)
> dblib.c:8002:FreeTDS: db-lib: exiting because client error handler
> returned INT_EXIT for msgno 20009
>
> This is one thing that I don't understand:
> > net.c:228:Connecting to 192.138.151.209 port 4000 (TDS version 5.0)
> What's that addr+port? Some weird legacy fallback?
>
> Ariel Cornejo
> +58·412·8083546
>
>
For the port there should be a -p parameter to fisql, or set environment
variable TDSPORT to override (you can also compile FreeTDS with --tds-ver
to get some different default, usual for mssql).

I'm a bit scared about the ip if this is different from the one you passed
from command line! Can you post your config.h (it's created in include
directory after you run configure command).

You can also try to define TDSDUMPCONFIG to another file (use also TDSDUMP)
to get configuration dumps.

Frediano



>
> On Tue, Jun 25, 2013 at 3:57 PM, Frediano Ziglio <freddy77 AT gmail.com>
> wrote:
> > Applied the patch (and tested with Linux). Ariel, can you try updating
> your
> > FreeTDS ??
> >
> > Thanks,
> >   Frediano
> >
> >
> > 2013/6/21 Peter Deacon <peterd AT iea-software.com>
> >
> >>
> >> On Fri, 21 Jun 2013, arielCo wrote:
> >>
> >> > Interesting (not that I understand):
> >>
> >> Thanks, I'll send in a patch.
> >>
> >> regards,
> >> Peter
>
>