FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Adam Prime x443
> Sent: Friday, October 29, 2004 10:19 AM
> 
> I fixed the problem with the help provided by you guys.  it ended up
being two-fold.
> 
> 1) I needed to recompile DBD::Sybase using the new version of FreeTDS.
> 2) I needed to make sure the fields were ntext, not text (in this
case)
> 
> Once that was done, changing the client charset fixed it up.  

Excellent.  Maybe the reason you needed to recompile DBD::Sybase, even
though it was dynamically linked, is that the major version number
changed.  You produced a new version of ct-lib, but old one was still
around and was preferred (or required) by DBD::Sybase.  

To discover which libraries DBD::Sybase is using, you could ask ldd(1)
thus:

$ find $(perl -e'print join $/, @INC') -name '*Sybase.so' |uniq |xargs
ldd

/usr/pkg/lib/perl5/site_perl/5.6.1/i386-netbsd/auto/DBD/Sybase/Sybase.so
:
         -lperl => /usr/pkg/lib/perl5/5.6.1/i386-netbsd/CORE/libperl.so
         -liconv.3 => /usr/pkg/lib/libiconv.so.3
         -lct.1 => /usr/pkg/lib/libct.so.1
         -lintl.0 => /usr/lib/libintl.so.0
         -ltds.2 => /usr/pkg/lib/libtds.so.2
         -lm.0 => /usr/lib/libm387.so.0
         -lm.0 => /usr/lib/libm.so.0

As you can see, on this machine I'm using libct.so.1, an old version.
You probably were, too.  Now that you've relinked, you're using
libct.so.3, and all is well.  

--jkl


-----Original Message-----
From: James K. Lowden [mailto:jklowden AT schemamania.org]
Sent: Thursday, October 28, 2004 10:53 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Re: hex(92), freeTDS and MS SQL


"Adam Prime x443" <aprime AT brunico.com> wrote:
> 
> How can i figure out which version of freetds is actually being used?
> 
> DBD::Sybase was compiled against an older version but i thought that
if
> i overwrote all the libraries with the new install that would be ok. 
> but i guess that depends on whether or not DBD::Sybase is statically
or
> dynamically linked.  I think it's dynamically linked though because
when
> i renamed the freetds directory DBD::Sybase broke.

The TDSDUMP log has included version information at the top since 9 Dec
2002, a little after 0.60 was released.  UTF-8 support and generalized
charset handling was introduced in 0.62.  So, your log should indicate
the
version.  

Since you're running in a web server, it might be that your TDSDUMP log
is
getting overwritten with each new connection.  You want "dump file
append
= yes" in freetds.conf.  

--jkl

-----------------------------------------
The information contained in this transmission may contain privileged and 
confidential information and is intended only for the use of the person(s) 
named above. If you are not the intended recipient, or an employee or agent 
responsible for delivering this message to the intended recipient, any 
review, dissemination, distribution or duplication of this communication is 
strictly prohibited. If you are not the intended recipient, please contact 
the sender immediately by reply e-mail and destroy all copies of the original 
message. Please note that we do not accept account orders and/or instructions 
by e-mail, and therefore will not be responsible for carrying out such orders 
and/or instructions.
If you, as the intended recipient of this message, the purpose of which is to 
inform and update our clients, prospects and consultants of developments 
relating to our services and products, would not like to receive further 
e-mail correspondence from the sender, please "reply" to the sender 
indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New York, 
NY 10105.