Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC limitations?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Andrew Shuttlewood <andrew.shuttlewood AT futureroute.co.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC limitations?
  • Date: 25 Feb 2003 17:09:10 +0000

On Tue, 2003-02-25 at 16:33, ZIGLIO Frediano wrote:
> >
> > I have an SQL Query which is
> >
> > {? = CALL [sp_insertCharacter](?)}
> >
> > Which fails, and generates the following error (going through the
> > disgusting error API)
> >
> > Record number 3, error code = 00000 and error string = Msg 170, Level
> > 15, State 1, Server SQL, Line 1
> > Line 1: Incorrect syntax near '='.
> >
> > Note: this works with Microsoft's ODBC driver.
> >
> > Is this unsupported in freetds? Or is there an alternative syntax that
> > should be used instead?
> >
>
> IMHO this is a ms odbc bug...
> Syntax so not allow spaces...
> Try {?=call [sp_insertCharacter](?)}
> or {?=call sp_insertCharacter(?)}

I've changed it to what you suggested (indeed, a direct copy/paste jobby
after modifying it myself didn't work) and I get

Record number 3, error code = 00000 and error string = Msg 170, Level
15, State 1, Server SQL, Line 1
Line 1: Incorrect syntax near '?'.

I get the same problems for both approaches (both with and without the
[]s)




Archive powered by MHonArc 2.6.24.

Top of Page