FreeTDS Development Group

[Rob Booth <robert.booth AT bridgepointeducation.com>]

I haven't applied any patches, just did a clean install from the latest
stable release.  I'll look into the available patches and apply them and
test.

Let me know if there is any other information from the log file that you'd
like to see.

Rob

On 6/16/10 12:43 AM, "Frediano Ziglio" <freddy77 AT gmail.com> wrote:

> 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
_______________________________________________
FreeTDS
> mailing 
> list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freet
> ds


Rob Booth |  Senior Software Engineer
Bridgepoint Education  |  Higher access to higher education
858.513.9240 x2716  Office

robert.booth AT bridgepointeducation.com
http://www.bridgepointeducation.com


IMPORTANT NOTICE: This e-mail message is intended to be received only by 
persons entitled to receive the confidential information it may contain. 
E-mail messages sent from this company may contain information that is 
confidential and may be legally privileged. Please do not read, copy, forward 
or store this message unless you are an intended recipient of it. If you 
received this transmission in error, please notify the sender by reply e-mail 
and delete the message and any attachments.