FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Tue, 2002-05-14 at 15:32, Michael Hudin wrote:
> Okay, so I'm going crazy trying to get my Linux server to properly pull
> out large files from the database.  I'm using Redhat 7.2 with Perl 5.6.1,
> freetds 0.53, and DBD Sybase.  The system is accessing a NT 4.0 SP6 system
> with MSSQL Server 7 SP4 on it.
> 
> For some reason I've not been able to get the system to use TDS 7.0.  It
> seems to run fine with 4.2 (but with the aforementioned problem) but if I
> set it 7.0 in the freetds.conf file, it simply won't pull any of the
> information from the database at all and gives an "out of memory" error
> which I find peculiar.  Anyone know anything about this?

MSSQL defaults the TEXTSIZE value to 2GB. So DBD::Sybase (and/or
FreeTDS) when it sees a TEXT or IMAGE datatype column will get a size
value of 2GB, and will try to allocate that much memory...

You can reduce that with a 

$dbh->do("set textsize <some reasonable value>");

Maybe FreeTDS should issue this by default to enable the normal default
behavior of textsize set to 32k...

(or maybe DBD::Sybase should do this - but this isn't necessary for
Sybase databases...)

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler AT peppler.org           *or*          mpeppler AT mbay.net
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com

Attachment: signature.asc
Description: This is a digitally signed message part