FreeTDS Development Group

["Brug, Herco van -Syntegra NL" <H.vanBrug AT syntegra.nl>]

ok, so it appears we have a MSSQL 6.5 server here that doesnt speak TDS70.
i'm stuck with 4.2 unfortunately. i compiled freetds to use tds70
(appearently the putenv("TDSVER=70") doesnt do much) but now it tells me it
failed to connect. it can find the server but can not talk to it (or so it
seems). any ideas how to solve the 255char barrier?

-----Original Message-----
From: Brug, Herco van -Syntegra NL [mailto:H.vanBrug AT syntegra.nl]
Sent: woensdag 1 november 2000 14:48
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries


i did compile freetds with tdsver 4.2 but i was under the impression that
when you put a 'putenv("TDSVER=70") in your phtml page, the version used was
7.0. i tried that and got the same result (text cut off at 255 chars). any
other way to correct this problem? i'm rebuilding freetds now and will post
what happens 

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org]
Sent: maandag 30 oktober 2000 18:54
To: TDS Development Group
Subject: [freetds] Re: 255 char limit in result queries


> anybody aware of a problem with freetds that makes results from queries be
> cut off at 255 chars? using odbc connection it returns all pages from the
db
> but using freetds as layer it stops at 250 and some chars. is there a
patch
> or fix for this problem?
> 

I'll assume you are referring to char/varchars types of > 255 in SQL
Server 7.0 being truncated to 255? The usual cause of this is that you're
using TDS 4.2 instead of TDS 7.0.  Configure freetds with the
--with-tdsver=7.0 flag to correct.

Brian

---
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: [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
-----------------------------