freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] ODBC stored procedures broken in CVS?
- From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] ODBC stored procedures broken in CVS?
- Date: Wed, 30 Nov 2005 13:16:23 +0100
>
> When I SQLExecDirect a simple query like:
>
> {CALL myproc('value')}
>
> Something is attempting to parse/prepare my procedure call the
> database error I'm getting back is along the lines of "the required
> parameter of myproc is missing"
>
> Checking profiler my procedure is being sent as 'myproc' only
> with the
> constant 'value' parameter stripped out.
>
> It looks like this happened with changes between 1.19 and 1.22 of
> native.c.
>
> I fixed it for me easy enough by moving the return
> SQL_SUCCESS; in the
> default switch case unconditionally in prepare_call.. but I
> suspect there
> needs to be some sort of memory of previous
> parameters/counter to bail out
> if one or more place holders are found and I suspect
> something else might
> not be right... I'm too ignorant in this area to try and submit a
> patch...sorry :(
>
> take care,
> Peter
You are right... fixed in CVS (attached patch).
Well, we implemented RPC calls using ALWAYS RPC calls but we do not
handle this case (RPC with no dynamic parameters)
freddy77
Attachment:
vedi.diff
Description: vedi.diff
-
[freetds] ODBC stored procedures broken in CVS?,
Peter Deacon, 11/29/2005
- <Possible follow-up(s)>
- Re: [freetds] ODBC stored procedures broken in CVS?, ZIGLIO, Frediano, VF-IT, 11/30/2005
Archive powered by MHonArc 2.6.24.