freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] trouble passing (var)char data to and from stored procedures

From: "Alexander Urmazov" <alexurm AT gmail.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] trouble passing (var)char data to and from stored procedures
Date: Thu, 16 Mar 2006 13:18:46 +0300

Yes, you are right.
When I set length for input parameter to -1 all became fine.

Thank you!

2006/3/15, Allan Kim <akim AT freedom.com>:
>
> If I'm not mistaken, mssql_bind() is pretty much just a wrapper for
> dbrpcparam() in rpc.c. That function normally logs an entry like
> "dbrpcparam added parameter" -- if you don't see that in the dump logs,
> I'd suspect that you're failing input validation in dbrpcparam (most of
> which was added post-0.62).
>
> One possibility ... are you trying to bind an input parameter? If so you
> may not need to specify MAXLEN. Here's something from the published
> specs from our friends in Redmond:
>

[freetds] trouble passing (var)char data to and from stored procedures, Alexander Urmazov, 03/14/2006
- Re: [freetds] trouble passing (var)char data to and from stored procedures, James K. Lowden, 03/14/2006
- Re: [freetds] trouble passing (var)char data to and from stored procedures, Allan Kim, 03/14/2006
  - Re: [freetds] trouble passing (var)char data to and from stored procedures, Ellert van Koperen, 03/15/2006
  - Re: [freetds] trouble passing (var)char data to and from stored procedures, Alexander Urmazov, 03/16/2006