FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Hmmm...try:

set textsize 65536

before issuing your query and see if that helps, adjust the number if
your textfields are larger than 64k.

Brian

On Thu, 2 Nov 2000, Brug, Herco van -Syntegra NL wrote:

> i run the freetds snapshot from the freetds.com site (which is v0.5 i
> think). the query we run is: 
>   $r1=mssql_query("Select dbo.SUPPORTPROJECT.Proj_toel,
> dbo.SUPPORTPROJECT.Proj_antwoord FROM dbo.SUPPORTPROJECT Where
> (Proj_nr=$pn)");
> the proj_toel and proj_antwoord fields are both textfields in the database
> that can be several KB long. the same query run on an NT box (odbc_do(.))
> gives the full result so i know the fields are filled. the version mssql
> server is 6.5... 
> i suspect freetds to be the one failing in this. perhaps i should try to get
> an odbc client running on the linuxbox but i'd rather use freetds so i'd
> very much like to have this solved. 
> 
> -----Original Message-----
> From: Mark Schaal [mailto:mark AT champ.tstonramp.com]
> Sent: woensdag 1 november 2000 19:58
> To: TDS Development Groupn 
> Subject: [freetds] Re: 255 char limit in result queries
> 
> 
> 
> I wasn't able to reproduce this here under TDS4.2/MSSQL7.0.  I'm not
> sure we have a MSSQL6.5 machine around anymore.  
> 
> Are you running a recent freetds version from the CVS repository?
> If not, please try that first as it has numerous improvements over
> the released version.
> 
> If you could post a simple test case of the SQL statements you run
> which fail, I'd be glad to run it here.
> 
> Mark
> -- 
> Mark J. Schaal                                        Phone:      (909) 
> 620-7724
> TST On Ramp                                   Fax:        (909) 620-8174
> System Administrator                          E-Mail: mark AT tstonramp.com
> 
> ---
> You are currently subscribed to freetds as: [H.vanBrug AT syntegra.nl]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
> 
> -----------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from any
> computer.
> -----------------------------
> Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder
> Syntegra goederen en diensten levert zijn met uitsluiting van alle andere
> voorwaarden onze algemene voorwaarden van toepassing. Deze worden u op
> aanvraag direct kosteloos toegezonden. Tevens kunt u deze vinden via onze
> homepage http://www.syntegra.nl
> -----------------------------
> On all offers and agreements under which Syntegra supplies goods or services
> of whatever nature, the general terms and conditions from Syntegra Groep
> B.V. exclusively apply. The general terms and conditions shall be promptly
> submitted to you on your request. You can also find these via our homepage
> http://www.syntegra.nl
> -----------------------------
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>