FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2010/6/15 Rob Booth <robert.booth AT bridgepointeducation.com>:
> I sent an email to the list a week or so ago about this, but didn¹t get any
> responses so I thought I¹d try again.  I installed freetds-0.82 on my Mac
> after upgrading to Snow Leopard.  Everything seemed to go fine until I ran
> into some stored procedure calls from my PHP code that returned this error:
>
> ³No tuples available at this result index²
>
> After looking into the logs and searching the internet I wasn¹t able to find
> any solution.  I did however see that when I call a stored procedure that
> works and one that doesn¹t I get some different results.
>
> Good Results Log:
> 13:04:15.516355 1650 (net.c:671):Received packet
> 0000 81 22 00 00 00 01 00 a7-0a 00 09 04 d0 00 34 04 |."...... ......4.|
> 0010 62 00 62 00 69 00 64 00-00 00 10 00 38 0b 53 00 |b.b.i.d. ....8.S.|
> 0020 79 00 53 00 74 00 75 00-64 00 65 00 6e 00 74 00 |y.S.t.u. d.e.n.t.|
> 0030 49 00 44 00 00 00 01 00-a7 34 00 09 04 d0 00 34 |I.D..... .4.....4|
> 0040 0b 73 00 74 00 75 00 64-00 65 00 6e 00 74 00 4e |.s.t.u.d .e.n.t.N|
> 0050 00 61 00 6d 00 65 00 00-00 09 00 af 23 00 09 04 |.a.m.e.. ....#...|
> 0060 d0 00 34 04 74 00 65 00-72 00 6d 00 00 00 01 00 |..4.t.e. r.m.....|
> 0070 a7 0c 00 09 04 d0 00 34-0a 63 00 6f 00 75 00 72 |.......4 .c.o.u.r|
> 0080 00 73 00 65 00 43 00 6f-00 64 00 65 00 00 00 08 |.s.e.C.o .d.e....|
> 0090 00 a7 4b 00 09 04 d0 00-34 0a 63 00 6f 00 75 00 |..K..... 4.c.o.u.|
>
> 13:04:15.518419 1650 (token.c:573):4 hidden return parameters
> 13:04:15.518427 1650 (token.c:580):stored internal cursor id 180150003
>
> Bad Results Log:
> 13:04:34.240256 1649 (net.c:671):Received packet
> 0000 ab 9e 00 3a 42 00 00 01-00 22 00 45 00 78 00 65 |...:B... .".E.x.e|
> 0010 00 63 00 75 00 74 00 69-00 6e 00 67 00 20 00 53 |.c.u.t.i .n.g. .S|
> 0020 00 51 00 4c 00 20 00 64-00 69 00 72 00 65 00 63 |.Q.L. .d .i.r.e.c|
> 0030 00 74 00 6c 00 79 00 3b-00 20 00 6e 00 6f 00 20 |.t.l.y.; . .n.o. |
> 0040 00 63 00 75 00 72 00 73-00 6f 00 72 00 2e 00 0a |.c.u.r.s .o.r....|
> 0050 41 00 55 00 43 00 41 00-2d 00 53 00 51 00 4c 00 |A.U.C.A. -.S.Q.L.|
> 0060 30 00 32 00 1d 75 00 73-00 70 00 6d 00 61 00 5f |0.2..u.s .p.m.a._|
> 0070 00 66 00 61 00 53 00 74-00 75 00 64 00 65 00 6e |.f.a.S.t .u.d.e.n|
> 0080 00 74 00 4c 00 65 00 64-00 67 00 65 00 72 00 43 |.t.L.e.d .g.e.r.C|
> 0090 00 61 00 72 00 64 00 49-00 6e 00 66 00 6f 00 37 |.a.r.d.I .n.f.o.7|
> 00a0 00 ff 01 00 c6 00 00 00-00 00 ff 01 00 c8 00 00 |........ ........|
> 00b0 00 00 00 ff 11 00 c3 00-0c 00 00 00 ff 11 00 c5 |........ ........|
> 00c0 00 0c 00 00 00 81 0a 00-00 00 10 00 38 08 4c 00 |........ ....8.L.|
> 00d0 65 00 64 00 67 00 65 00-72 00 49 00 44 00 00 00 |e.d.g.e. r.I.D...|
> 00e0 08 00 38 09 53 00 61 00-54 00 72 00 61 00 6e 00 |..8.S.a. T.r.a.n.|
> 00f0 73 00 69 00 64 00 00 00-08 00 38 07 54 00 72 00 |s.i.d... ..8.T.r.|
>
> 13:04:34.245846 1649 (token.c:573):4 hidden return parameters
> 13:04:34.245855 1649 (token.c:580):stored internal cursor id 0
>
> For some reason the Bad results have this header block before the column
> names actually start, and a 0 for the cursor id that is getting stored.
> Does anyone have any thoughts on this.  Is there some setup that I can do to
> make this work?
>
> Thanks,
> Rob
>

Thanks to post again.

It would be interesting to understand client query (packets
pre-results). Are you applied post 0.82 patches at freetds.sf.net ?? I
remember a fix for cursor request that do not return a cursor.

freddy77