Skip to Content.
Sympa Menu

freetds - Re: [freetds] stop the presses....0.61rc2

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] stop the presses....0.61rc2
  • Date: 23 Feb 2003 12:44:27 +0100

Il sab, 2003-02-22 alle 20:36, Brian Bruns ha scritto:
> I believe that is used for rpc (server to server) connections right?
> Sybase has those zeroed in client-to-server streams i believe. Perhaps, MS
> has them on all the time?
>
> Brian
>

I tested today with a mssql2k server.
These are the results of 3 connect to same server (same using TDS7 and TDS8)

Sending packet @ 2003-02-23 12:34:44.325524
0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |...".... s.e.l.e.|
0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@. @.s.p.i.|
0020 64 00 |d.|


Received header @ 2003-02-23 12:34:44.326833
0000 04 01 00 1d 00 39 01 00 |.....9..|


Received packet @ 2003-02-23 12:34:44.326954
0000 81 01 00 00 00 00 00 34 00 d1 39 00 fd 10 00 c1 |.......4 .Ñ9.ý..Á|
0010 00 01 00 00 00 |.....|

--------------------

Sending packet @ 2003-02-23 12:34:51.329333
0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |...".... s.e.l.e.|
0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@. @.s.p.i.|
0020 64 00 |d.|


Received header @ 2003-02-23 12:34:51.330488
0000 04 01 00 1d 00 3a 01 00 |.....:..|


Received packet @ 2003-02-23 12:34:51.330607
0000 81 01 00 00 00 00 00 34 00 d1 3a 00 fd 10 00 c1 |.......4 .Ñ:.ý..Á|
0010 00 01 00 00 00 |.....|

--------------------

Sending packet @ 2003-02-23 12:34:36.002745
0000 01 01 00 22 00 00 01 00 73 00 65 00 6c 00 65 00 |...".... s.e.l.e.|
0010 63 00 74 00 20 00 40 00 40 00 73 00 70 00 69 00 |c.t. .@. @.s.p.i.|
0020 64 00 |d.|


Received header @ 2003-02-23 12:34:36.003946
0000 04 01 00 1d 00 38 01 00 |.....8..|


Received packet @ 2003-02-23 12:34:36.004067
0000 81 01 00 00 00 00 00 34 00 d1 38 00 fd 10 00 c1 |.......4 .Ñ8.ý..Á|
0010 00 01 00 00 00 |.....|

Same server using TDS 4.2

Sending packet @ 2003-02-23 12:38:06.218249
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|


Received header @ 2003-02-23 12:38:06.220349
0000 04 01 00 20 00 39 01 00 |... .9..|


Received packet @ 2003-02-23 12:38:06.220462
0000 a0 01 00 00 a1 05 00 06 00 00 00 34 d1 39 00 fd | ...¡... ...4Ñ9.ý|
0010 10 00 c1 00 01 00 00 00 |..Á.....|

-------------------

Sending packet @ 2003-02-23 12:37:58.342963
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|


Received header @ 2003-02-23 12:37:58.344814
0000 04 01 00 20 00 38 01 00 |... .8..|


Received packet @ 2003-02-23 12:37:58.344937
0000 a0 01 00 00 a1 05 00 06 00 00 00 34 d1 38 00 fd | ...¡... ...4Ñ8.ý|
0010 10 00 c1 00 01 00 00 00 |..Á.....|

-------------------

Sending packet @ 2003-02-23 12:38:13.327598
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|


Received header @ 2003-02-23 12:38:13.329532
0000 04 01 00 20 00 3a 01 00 |... .:..|


Received packet @ 2003-02-23 12:38:13.329680
0000 a0 01 00 00 a1 05 00 06 00 00 00 34 d1 3a 00 fd | ...¡... ...4Ñ:.ý|
0010 10 00 c1 00 01 00 00 00 |..Á.....|

You can note in every packet headers

04 01 00 20 00 3a 01 00
^^ ^^ same as @@spid

If someone can test same behavior with mssql7 or former...

freddy77





Archive powered by MHonArc 2.6.24.

Top of Page