Re: Truncation of Results from SqlDataReader

John, I don't know if this is the same thing I ran into but when I recently
created a web service to accept a new claim into our accounts receivable
system, I had defined the XMLDocument argument as type string (later
converting that to an actual XML document in the function).  There is a size
limitation of around the size you're seeing and I'm wondering if you're
running into the same thing.

I'm not sure my solution of changing the argument to an XML Node is going to
help but it may provide the clue you need.  Hope this helps.

John H.


On 9/12/06, John Wilkinson <[email protected]> wrote:
>
> I have a stored procedure that generates an XML stream.  The stream is
> read with a SqlDataReader object, using GetSqlString.  However, the
> string is truncated at 2034 characters.  The same thing happens when the
> result is retrieved with GetString.  The stored procedure has been
> verified to return the correct and complete string.
>
> Any ideas on what might be causing this?  Or how to get around it?
>
> Thanks,
>
> John
>
> ===================================
> This list is hosted by DevelopMentor(r)  http://www.develop.com
>
> View archives and manage your subscription(s) at
> http://discuss.develop.com
>

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com