FreeTDS Development Group

["Jussi Kuosa" <jussi.kuosa AT tellabs.com>]

Hello,
I'm building a connection from Tcl shell in a GNU/Linux (RH 7.2) server to
a MS SQLServer 6.5 running on a NT 4 server using ODBC. I.e.
TclODBC+Tcl+unixODBC+FreeTDS run in the GNU/Linux server.

So far I have tried FreeTDS 0.52 and then 0.53pre3 that got me connected
to the database using SQSH:

$ sqsh -S SERVER.tellabs.fi -U UID -P PWD -D DATABASE
        > select * from TABLE
        > \go
        ### OK!!! ###
        > \exit

For the 0.53pre3 release of FreeTDS I have also done 'make check' with a
valid PWD file and all tests now pass, after patching the following tests
from the CVS web interface:
    * ctlib: t0004.c
    * dblib: t0009.c

>From this I concluded that I should have a well set up FreeTDS
installation/configuration. *But* when I try to run unixODBC isql to the
configured DSN I get connected and a 'Segmentation fault' after pressing
return on the SQL> prompt.

Initially I thought that this would be a unixODBC issue and mailed to Nick
Gorham (unixODBC maintainer), who instructed me to contact Brian on this
matter. After reading the mailing list backwards (and understanding not to
mail directly...), I guess I should use the very latest snapshot. However,
CVS access well blocked by our firewall, so can I apply the patch in the
snapshot file
(http://ibiblio.org/pub/Linux/ALPHA/freetds/freetds-current.tgz)to the
0.53pre3 sources and use that?

Has using the latest snapshot cured all other GNU/Linux installations?

What can I do to provide more information?


Any help is warmly welcomed,

    Jussi Kuosa

e. jussi.kuosa AT tellabs.com

### DEBUG INFO ###
I have used the current
http://www.unixodbc.org/unixODBC-2.1.0.tar.gz sources with
the following procedure:
$ ./configure --quiet --enable-gui=no
$ make
$ su, pwd
# make install

For freeTDS
http://ibiblio.org/pub/Linux/ALPHA/freetds/freetds-0.53pre3.tgz I used:
$ ./configure --prefix=/usr/local --with-unixodbc=/usr/local
--with-tdsver=4.2 --quiet
$ make
$ su, pwd
# make install

$ echo $SYBASE
/usr/local
$ echo $LD_LIBRARY_PATH
/usr/local/lib
$ echo $TDSVER
42   (I guess this is unnecessary as I used tdsver=4.2?)

The NT server is up and running (ping, telnet to port 1433 both ok), and I
can also contact it with whatever SQL tools MS world has (including Tcl +
tclODBC, and MS isql).

$ ldd /usr/local/bin/isql
        libodbc.so.1 => /usr/local/lib/libodbc.so.1 (0x40017000)
        libodbcinst.so.1 => /usr/local/lib/libodbcinst.so.1 (0x4006f000)
        libdl.so.2 => /lib/libdl.so.2 (0x40084000)
        libreadline.so.4 => /usr/lib/libreadline.so.4 (0x40088000)
        libncurses.so.5 => /usr/lib/libncurses.so.5 (0x400ae000)
        libm.so.6 => /lib/libm.so.6 (0x400f0000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x40112000)
        libc.so.6 => /lib/libc.so.6 (0x40129000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)