FreeTDS Development Group

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

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)