FreeTDS Development Group

["Sam Sam" <s4m AT lycos.com>]

Hello there... 
I've been using freetds since 4 months ago and it went fine.. until 
yesterday, the connection to the database server went slow when accessed from 
webserver, but it ran smoothly if I do query from php binary.  The webserver 
is fine when serving static html files but went slow when had to access 
database server.

I try to figure it out a hour.. and found that removing these two lines from 
apachectl script will make the webserver run smoothly as usual:
export SYBASE=/pathto/freetds
export LD_LIBRARY_PATH=/pathto/freetds/lib    

I configure and compiled my apache 1.3.12 webserver with these options..
./configure' '--with-apache=../apache_1.3.12' 
'--with-sybase-ct=/data/freetds' '--with-mysql' '--with-imap'

anyone can explain these ?? just curious...

cheers,
Sam






Get your small business started at Lycos Small Business at 
http://www.lycos.com/business/mail.html

From falmeida AT cidadei.com.br Fri Jan 19 08:58:21 2001
X-Mailer: Lyris Web Interface
Date: Fri, 19 Jan 2001 08:58:18 -0500
Subject: Re: problem with using DBD-Sybase & perl
To: freetds AT franklin.oit.unc.edu
From: "Fernando Costa de Almeida" <falmeida AT cidadei.com.br>


        Hi,

        I have a scenario like you, and Im getting the same errors. Ive just
signed to this list, if youve found the asnwer to this error, could you
please forward me the mesg?

        Thank you very much

> Dear all,
> 
> I'm having a problem using DBD::Sybase,Perl,and FreeTDS. I'm currently 
> working with FreeTDS v0.51, perl 5.005_03, DBD::Sybase v0.91, Debian Linux,
> v2.2. I'm also connecting to a MS SQL 2000 server, using TDS v7.0.
> 
> Here's the problem:
> Whenever I attempt to execute any kind of SELECT statement, I get an Out of
> Memory error.
> my $sth = $db->prepare("SELECT * FROM Savings");
> $sth->execute; <---out of memory happens on that line
> 
> Any help would be appreciated. Thanks.
> 
> Signed,
> Gil Cohen
> p.s. this is a very small table.
> 
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com