Skip to Content.
Sympa Menu

freetds - Could someone try out something for me ?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bill Thompson" <thompbil AT exchange.uk.ml.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Could someone try out something for me ?
  • Date: Thu, 3 Oct 2002 11:26:29 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page