Increasing the buffer size so I can do a large INSE RT

Chris Given term at
Mon Aug 21 15:01:32 EDT 2000

Max batch execute size in MS SQL is 640000

-----Original Message-----
From: Gordon Fong [mailto:g.fong at]
Sent: Sunday, August 20, 2000 7:00 PM
To: TDS Development Group
Subject: [freetds] Increasing the buffer size so I can do a large INSERT

I have a simple INSERT statement that has a variety of variables which 
contain at most 500 characters, and this attempts to create a new record in 
my MS SQL v7 database. A lot of my requests are failing when I have too 
much text. I have tried increasing the field widths or changing their types 
without much success.

I checked the archive and saw an issue about setting tds->out_buf size to 
something larger than the default 512.

My question is how do I do this in Perl ? Do I set environment variables or 



You are currently subscribed to freetds as: term at
To unsubscribe, forward this message to

More information about the FreeTDS mailing list