FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

Could you post some more lot, describing what query are you issuing to
server and how (which PHP functions are you using) ?

freddy77

2010/6/16 Rob Booth <robert.booth AT bridgepointeducation.com>:
> Ok, I've now tried this with 0.82.1 and 0.83 with the same results.  Let me
> know if there is any other information that I can supply to help figure this
> out.
>
> Thanks,
> 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
>
>
> 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.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>