[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