freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Peter Deacon <peterd AT iea-software.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] ODBC stored procedures broken in CVS?
- Date: Tue, 29 Nov 2005 18:16:59 -0800 (Pacific Standard Time)
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
-
[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.