Skip to Content.
Sympa Menu

freetds - Re: MSSQL for XML

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: MSSQL for XML
  • Date: Sat, 1 Jun 2002 06:49:11 -0400


On Fri, 31 May 2002 16:56:01 -0400 "DJ Sures" <dj AT securityfocus.com>
wrote:
> When I execute the the following query in a stored proc :
> [--- cut ---]
> DECLARE @text varchar(8000)
> set @text=replicate('1', 500)
> set textsize 8000
> SELECT @text as [col1] for XML RAW
> [-----------]
> I receive only 255 characters of the expected (500 + xml garbage). If i
> remove the "set textsize" then i get the obvious "Out of memory!" error
> from freetds.
>
> FreeTDS Version: 0.53
> DBD-Sybase: 0.91

Are you using SQL Server 2000, and are you sure you're running TDS 7.0?
The symptom you describe is consistent with a TDS 4.2 connection.

Try "export TDSVER=7.0" (or similar) before launching your application,
just to make sure.

HTH.

--jkl



  • Re: MSSQL for XML, James K. Lowden, 06/01/2002

Archive powered by MHonArc 2.6.24.

Top of Page