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:15:31 +0000

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)





Archive powered by MHonArc 2.6.24.

Top of Page