FreeTDS Development Group

["ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>]

> -----Original Message-----
> From: Roland Bole [mailto:Samlinux AT gmx.at] 
> Sent: Thursday, December 18, 2003 5:45 PM
> To: FreeTDS Development Group
> Subject: RE: AW: [freetds] connect problem to mssql 7.0
> 
> 
> > > 
> > > > Did you add /usr/local/freetds/lib to /etc/ld.so.conf ?
> > > Yes I did.
> > > 
> > > >You can use
> > > > LD_LIBRARY_PATH environment but it's better (for system
> > > wise reasons) to
> > > > use /etc/ld.so.conf.
> > > >After editing the file launch ldconfig to update system.
> > > 
> > > Ok,
> > > 
> > > But the error is still there.
> > > 
> > > Roland
> > > 
> > 
> > Strange...
> > 
> > $ ldd /usr/local/freetds/bin/tsql
> >         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x4002a000)
> >         libreadline.so.4.1 => /usr/lib/libreadline.so.4.1 
> (0x4006c000)
> >         libtds.so.2 => /home/fziglio/test2/lib/libtds.so.2
> > (0x40092000)
> >         libc.so.6 => /lib/i686/libc.so.6 (0x400c6000)
> >         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
> > 
> > (note libtds.so.2 line)
> > 
> > $ nm /usr/local/freetds/lib/libtds.so.2 | grep charset 000311e0 d 
> > canonic_charsets 0001f1a4 t lcid2charset
> > 0001ee20 T tds7_srv_charset_changed
> > 0001f078 t tds_canonical_charset
> > 0001f0bc T tds_canonical_charset_name
> > 0000e6cc T tds_set_client_charset
> > 0001ed88 T tds_srv_charset_changed
> > 0001f0f0 T tds_sybase_charset_name
> > 
> > I don't have tds_set_charset....
> > 
> > $ nm src/apps/.libs/tsql | grep charset
> >          U tds_set_client_charset
> > 
> > neither...
> > 
> > That's very strange... Perhaps have you others freetds 
> installations 
> > (some headers, old library...) ?
> > 
> > freddy77
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org 
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> 
> to compare:
> 
> ldd /usr/local/freetds/bin/tsql 
>         libtds.so.2 => /usr/local/lib/libtds.so.2 (0x40014000)

This is what I mean... tsql is trying to use an old version, located in
/usr/local/lib... you can bump version and recompile FreeTDS, just 
replace line

libtds_la_LDFLAGS       = -version-info 2:0:0

(in src/tds/Makefile.am) with

libtds_la_LDFLAGS       = -version-info 3:0:0

however you have to have all developements tools (automake/autoconf...)
Or you can delete/move/rename temporarily /usr/local/lib/libtds.so.2

>         libnsl.so.1 => /lib/libnsl.so.1 (0x4004b000)
>         libc.so.6 => /lib/libc.so.6 (0x40060000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
> 
> nm /usr/local/freetds/lib/libtds.so.2 | grep charset
> 00009c1c T tds_set_charset
> 
> >> I don't have tds_set_charset....
> i have it
> 


This is REALLY strange... 

> > > That's very strange... Perhaps have you others freetds 
> installations 
> > > (some headers, old library...) ?
> 
> i used your latest snapshot according your email.
> 

Yes, but your system seem to have multiple incompatible versions of
FreeTDS...

freddy77