FreeTDS Development Group

["Ron Creamer" <ron AT pageworks.com>]

Hi All,

I hope I'm not off topic, but sqsh's website says to direct questions 
over here so here I go:

I've just upgraded to freetds-0.61RC1 because I intend to use freetds to 
access a MS SQL Server via PHP 4.3 on linux. I'm running RedHat Linux 8.0.

I've compiled freetds with the following:

./configure \
        --prefix=/usr \
        --sysconfdir=/etc \
        --enable-threadsafe \
        --enable-msdblib \
        --with-tdsver=7.0 \
        --with-unixodbc=/usr

It compiles and installs fine. Tests ok to my server with tsql.

When I go to compile sqsh, configured with --prefix=/usr --with-readline
and run make, I get:
------------------------------------
make[1]: Entering directory `/usr/local/src/sqsh-2.1.src/src'
gcc -g -O2  -DSQSH_RC='"/usr/etc/sqshrc:${HOME}/.sqshrc"' 
-I/usr/incl
ude    -c -o cmd_alias.o cmd_alias.c
cc1: warning: changing search order for system directory "/usr/include"
cc1: warning:   as it has already been specified as a non-system directory
In file included from sqsh_config.h:267,
                 from cmd_alias.c:26:
sqsh_compat.h:50: conflicting types for `strerror'
/usr/include/string.h:243: previous declaration of `strerror'
In file included from sqsh_config.h:267,
                 from cmd_alias.c:26:
sqsh_compat.h:74:1: warning: "strchr" redefined
In file included from /usr/include/string.h:375,
                 from sqsh_config.h:185,
                 from cmd_alias.c:26:
/usr/include/bits/string2.h:390:1: warning: this is the location of the 
previous
 definition
make[1]: *** [cmd_alias.o] Error 1
make[1]: Leaving directory `/usr/local/src/sqsh-2.1.src/src'
make: *** [build-subdirs] Error 2
[root@pwpc2002 sqsh-2.1.src]#
------------------------------------

Also, sqsh comes with a freetds version binary, compiled against .52, 
but it also worked against .53. When I try to use this binary, it yelps:


/usr/bin/sqsh.bin: error while loading shared libraries: libct.so.0: 
cannot open shared object file: No such file or directory

It appears that freetds-0.61 instead makes these libcts*'s instead 
(/usr/lib)

-rw-r--r--    1 root     root      1025344 Feb  9 18:15 libct.a
-rwxr-xr-x    1 root     root          700 Feb  9 18:15 libct.la
lrwxrwxrwx    1 root     root           12 Feb  9 18:15 libct.so -> 
libct.so.1.0
lrwxrwxrwx    1 root     root           12 Feb  9 18:15 libct.so.1 -> 
libct.so.1.0
-rwxr-xr-x    1 root     root       584120 Feb  9 18:15 libct.so.1.0

and these libtds*'s
-rw-r--r--    1 root     root       932690 Feb  9 18:15 libtdssrv.a
-rwxr-xr-x    1 root     root          728 Feb  9 18:15 libtdssrv.la
lrwxrwxrwx    1 root     root           16 Feb  9 18:15 libtdssrv.so -> 
libtdssrv.so.1.0
lrwxrwxrwx    1 root     root           16 Feb  9 18:15 libtdssrv.so.1 
-> libtdssrv.so.1.0
-rwxr-xr-x    1 root     root       520807 Feb  9 18:15 libtdssrv.so.1.0
-rw-r--r--    1 root     root      1231610 Feb  9 18:15 libtdsodbc.a
-rwxr-xr-x    1 root     root          746 Feb  9 18:15 libtdsodbc.la
lrwxrwxrwx    1 root     root           17 Feb  9 18:15 libtdsodbc.so -> 
libtdsodbc.so.0.0
lrwxrwxrwx    1 root     root           17 Feb  9 18:15 libtdsodbc.so.0 
-> libtdsodbc.so.0.0
-rwxr-xr-x    1 root     root       686573 Feb  9 18:15 libtdsodbc.so.0.0
-rw-r--r--    1 root     root       831940 Feb  9 18:15 libtds.a
-rwxr-xr-x    1 root     root          707 Feb  9 18:15 libtds.la
lrwxrwxrwx    1 root     root           13 Feb  9 18:15 libtds.so -> 
libtds.so.2.0
lrwxrwxrwx    1 root     root           13 Feb  9 18:15 libtds.so.2 -> 
libtds.so.2.0
-rwxr-xr-x    1 root     root       470935 Feb  9 18:15 libtds.so.2.0


If I create a symlink between as libct.so.0 to libct.so.1
and one as libtds.so.0 to libtds.so.2.0 (just guessing)

sqsh complains: \connect: Unable to install message callback

Has anybody got sqsh 2.1 working against the latest freetds?

Thanks,

-Ron