[freetds] ODBC stored procedures broken in CVS?
Peter Deacon
peterd at iea-software.com
Tue Nov 29 21:16:59 EST 2005
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
More information about the FreeTDS
mailing list