FreeTDS Development Group

[Andrew Shuttlewood <andrew.shuttlewood AT futureroute.co.uk>]

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.