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

Chris Given term at rmci.net
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 e-mango.com]
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 
something?

Regards,

Gordon

---
You are currently subscribed to freetds as: term at rmci.net
To unsubscribe, forward this message to
$subst('Email.Unsub')



More information about the FreeTDS mailing list