Skip to Content.
Sympa Menu

freetds - [freetds] ODBC stored procedures broken in CVS?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page