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:28:35 +0000

On Tue, 2003-02-25 at 17:15, Andrew Shuttlewood wrote:
> On Tue, 2003-02-25 at 17:09, Andrew Shuttlewood wrote:
>
> > > 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)
>
> Just to reply to myself for a moment. The logfile produces
>
> Sending packet @ 2003-02-25 17:12:00.018005
> 0000 01 01 00 3c 00 00 01 00 65 00 78 00 65 00 63 00 |...<....
> e.x.e.c.|
> 0010 20 00 73 00 70 00 5f 00 69 00 6e 00 73 00 65 00 | .s.p._.
> i.n.s.e.|
> 0020 72 00 74 00 43 00 68 00 61 00 72 00 61 00 63 00 |r.t.C.h.
> a.r.a.c.|
> 0030 74 00 65 00 72 00 20 00 3f 00 20 00 |t.e.r. . ?. .|
>
>
> Received header @ 2003-02-25 17:12:00.018702
> 0000 04 01 00 6a 00 34 01 00 |...j.4..|
>
>
> Received packet @ 2003-02-25 17:12:00.018752
> 0000 aa 56 00 aa 00 00 00 01 0f 22 00 4c 00 69 00 6e |.V......
> .".L.i.n|
> 0010 00 65 00 20 00 31 00 3a 00 20 00 49 00 6e 00 63 |.e. .1.: .
> .I.n.c|
> 0020 00 6f 00 72 00 72 00 65 00 63 00 74 00 20 00 73 |.o.r.r.e .c.t.
> .s|
> 0030 00 79 00 6e 00 74 00 61 00 78 00 20 00 6e 00 65 |.y.n.t.a .x.
> .n.e|
> 0040 00 61 00 72 00 20 00 27 00 3f 00 27 00 2e 00 03 |.a.r. .'
> .?.'....|
> 0050 53 00 51 00 4c 00 00 01 00 fd 02 00 fd 00 00 00 |S.Q.L...
> ........|
> 0060 00 00 |..|
>
>
> 2003-02-25 17:12:00.018836 processing result tokens. marker is
> aa(ERROR)
> 2003-02-25 17:12:00.018858 inside tds_process_default_tokens() marker is
> aa(ERROR)
> 2003-02-25 17:12:00.018898 processing result tokens. marker is
> fd(DONE)
> 2003-02-25 17:12:00.018921 inside tds_process_end() more_results = 0,
> was_cancelled = 0
> SQLFreeHandle(3, 0xa414d60)

and again (sorry!)

I'm binding an out variable to the return (which is an int), and a
binary object to the second ?, which doesn't appear to be being
transferred, unless I'm missing something. It appears that the binds
succeed.






Archive powered by MHonArc 2.6.24.

Top of Page