freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] SP parameter cannot return more than 256 chars

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] SP parameter cannot return more than 256 chars
Date: Sun, 30 Nov 2008 17:22:08 +0100

Il giorno dom, 30/11/2008 alle 10.57 -0500, Federico Alves ha scritto:
> Freetds has a bug or a limitation
> I execute this query on tsql:
> "declare @iplist varchar(512),@z int exec tempdb.dbo.sip_redirect 44,
> @iplist out, @z out select @iplist,@z"
> but I only get back the first 256 characters on the variable @iplist, the
> rest is ignored, but I need the full 512 or more characters. How can we fix
> this limitation?
> I use the latest stable version. Parameter passing should be limited I guess
> to 64 K if possible.
>

Hi,
are you sure you are using the proper protocol version ?? I got
correct reply using 8.0 and 7.0, not using 4.2.

freddy77

[freetds] SP parameter cannot return more than 256 chars, Federico Alves, 11/30/2008
- Re: [freetds] SP parameter cannot return more than 256 chars, Frediano Ziglio, 11/30/2008