FreeTDS Development Group

["Bill Thompson" <thompbil AT exchange.uk.ml.com>]

Hi all, 

I'm getting some results from some tests that I don't understand.

I'm running ctlib/unittests/t0004 against a SQL server 2000 database using
TDS protocol version 7.0.

part of the tdsdump output ( you'll need to put turn this on for the
program ) shows the following exchange :

0000  01 01 00 4a 00 00 01 00 53  00 45 00 4c 00 45 00   |...J....S
.E.L.E.|
0010  43 00 54 00 20 00 2a 00 20  00 46 00 52 00 4f 00   |C.T. .*. 
.F.R.O.|
0020  4d 00 20 00 23 00 74 00 30  00 30 00 30 00 34 00   |M. .#.t.0
.0.0.4.|
0030  20 00 57 00 48 00 45 00 52  00 45 00 20 00 69 00   | .W.H.E.R .E.
.i.|
0040  64 00 20 00 3d 00 20 00 31  00                     |d. .=. .1 .|


2002-10-03 16:05:00 ct_send() succeeded
2002-10-03 16:05:00 inside ct_results()
Received header @ 2002-10-03 16:05:00
0000  04 01 00 2a 00 44 01 00                           |...*.D..|


Received packet @ 2002-10-03 16:05:00
0000  79 00 00 00 00 81 01 00 00  00 09 00 26 04 02 69   |y........
...&..i|
0010  00 64 00 d1 04 01 00 00 00  fd 10 00 c1 00 01 00   |.d.......
.......|
0020  00 00                                             |..|

As you may be able to see, we send a statement :

"select * from #t0004 where id = 1" 

and we receive back a packet of three messages with markers "0x79", "0x81"
and "0xd1" . These are , respectively , an RPC return status (!!!),
followed by the "results" message and the "row" message I would expect.

I'm very puzzled by the RPC return status message, I haven't made an RPC
call!

Could someone else verify this behaviour. If it can be independently
verified, I'll have to cope with it in the code...

regards,

Bill