Skip to Content.
Sympa Menu

freetds - RE: [freetds] Does SQLBindParameter work with SQLExecDirect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Does SQLBindParameter work with SQLExecDirect
  • Date: Wed, 6 Aug 2003 17:33:13 +0200

>
> Hi,
>
> I'm using FreeTDS 0.61 and TDS-ver is 7.0.
>
> I can get SQLBindParameter to work with
> SQLPrepare/SQLExecute, but it fails when I try SQLExecDirect.
>
> I get sqlState of HY000, nativeError=1, and the message
> is "Line 1: Incorrect syntax near '?'".
>
> Is this a known bug, or am I doing something daft? The MS API
> Reference implies this is a legal sequence of ODBC API calls.
> Alternatively - as this just not been implemented (yet)?
> (i.e. "just use SQLPrepare stoopid!" :-)
>
> For reference (and ridicule :-) here's a test snippet that fails...
>

This was fixed in CVS. I don't think to merge this stuff in 0.61 so
there are two solutions:
- wait 0.62 version (not that good...)
- use SQLPrepare.

Thanks for report and test.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page