Could someone try out something for me ?

Bill Thompson thompbil at exchange.uk.ml.com
Thu Oct 3 12:26:29 EDT 2002


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



More information about the FreeTDS mailing list