Skip to Content.
Sympa Menu

freetds - [freetds] MSSql, Snow Leopard, & PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Rob Booth <robert.booth AT bridgepointeducation.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] MSSql, Snow Leopard, & PHP
  • Date: Tue, 15 Jun 2010 14:21:01 -0700

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

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.




Archive powered by MHonArc 2.6.24.

Top of Page