[freetds] Why does crash freetds at $sth->prepare? Which clie nt version?

Lowden, James K LowdenJK at bernstein.com
Wed May 14 13:11:53 EDT 2003

> From: Knut Behrends [mailto:knb at gfz-potsdam.de]
> Sent: May 14, 2003 10:47 AM
> we have a SUSE linux box that can connect to a solaris 11.5 ASE, exec
> SPs, run simple selects using isql and tsql.
> However there is a perl script with a $sth->prepare clause 
> that causes a segmentation fault.
> We had freetds 0.6 installed, and now we have installed 0.61 
> twice into
> the same directory $SYBASE/OCS dir using the account of unix 
> user sybase and into the /usr/lib using the root account.
> the freetds.conf file (or files, as there exist several of 
> them now) set the freetds version to 5.0.

Did installing 0.61 solve the segmentation fault problem?  If not, and you'd
like further help, please post your TDSDUMP log, taking care to remove
sensitive information such as passwords.  A backtrace might be useful, too.

> Would it be more helpful to download the sybase 11.0 ASE rpms, install
> the client on the linux box and that's it? (Instead of ironing out the
> library issues with the freetds installation)

If you're using Sybase only, and Sybase provides client libraries for your
client OS, then you don't need FreeTDS.  By definition, the perfect Sybase
client library comes from Sybase.  

If you can't run Sybase's software at both ends, you need FreeTDS.  Our
implementation suffices for many situations, but not all.  You can see from
doc/api_status.txt that there are many functions we don't implement, and
some we might never implement.  OTOH, we're open source, and you can usually
get the help you need here.  

> I'd prefer freetds but its developers also say in the release 
> notes that it might crash ASE 12.5 DB servers for unknown reasons.

For reasons we don't understand, connecting to Sybase 12.5 servers with TDS
4.2 will crash them.  That's what the warning is about.  Using TDS 5.0 is
perfectly safe.  

There is currently an effort to improve our ct-lib, which is what Perl uses,
and it is among our goals to support DBD::Sybase as a transparent
replacement for Sybase's libraries.  

Hope this helps you in your decision.

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.

More information about the FreeTDS mailing list