Skip to Content.
Sympa Menu

freetds - RE: Output parameters (was: Strange things)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: Output parameters (was: Strange things)
  • Date: Thu, 21 Nov 2002 12:21:16 +0100



Arghhhh... raw tcpdump !!! Try to use ethereal, much better (even without
TDS support, TCP view is very good)

> 09:23:40.579039 dsl092-147-061.wdc1.dsl.speakeasy.net.4977 >
> mmdb2.nci.nih.gov.1433: P 174:201(27) ack 395 win 63846 (DF)
> 0x0000 4500 0043 427a 4000 8006 c025 425c 933d
> E..CBz@....%B\.=
> 0x0010 9c28 8653 1371 0599 b239 fe84 2e7d 2774
> .(.S.q...9...}'t
> 0x0020 5018 f966 3759 0000 0301 001b 0000 0100
> P..f7Y..........
> 0x0030 0500 7400 3000 3000 3200 3200 0000 0001
> ..t.0.0.2.2.....
> 0x0040 2604 00 &..

RPC (message type 3), see query.c (tds_prepare_execute)
like "EXEC t0002 CONVERT(INT,NULL)", I think Bill is working on this too...

> 09:23:40.606461 mmdb2.nci.nih.gov.1433 >
> dsl092-147-061.wdc1.dsl.speakeasy.net.4977: P 395:442(47) ack 201 win
> 17320 (DF)
> 0x0000 4500 0057 3055 4000 6e06 e436 9c28 8653
> E..W0U@.n..6.(.S
> 0x0010 425c 933d 0599 1371 2e7d 2774 b239 fe9f
> B\.=...q.}'t.9..
> 0x0020 5018 43a8 7406 0000 0401 002f 0036 0100
> P.C.t....../.6..
> 0x0030 ff11 00c1 0001 0000 0079 0000 0000 ac0d
> .........y......
> 0x0040 0000 0138 0000 0026 0404 2a00 0000 fe00
> ...8...&..*.....
> 0x0050 00e0 0001 0000 00 .......

0401 002f 0036 0100
Header
ff11 00c1 0001 0000 00
DONE_IN_PROC
79 0000 0000
RPC result (I don't remember name...)
ac0d 0000 0138 0000 0026 0404 2a00 0000
RETURNVALUE, INTN (26) 2a (42)
fe00 00e0 0001 0000 00
DONE_PROC

All tokens supported by libtds

> 09:23:40.606865 dsl092-147-061.wdc1.dsl.speakeasy.net.4977 >
> mmdb2.nci.nih.gov.1433: F 201:201(0) ack 442 win 63799 (DF)
> 0x0000 4500 0028 427b 4000 8006 c03f 425c 933d
> E..(B{@....?B\.=
> 0x0010 9c28 8653 1371 0599 b239 fe9f 2e7d 27a3
> .(.S.q...9...}'.
> 0x0020 5011 f937 9e82 0000 P..7....

TCP ACK

> 09:23:40.633922 mmdb2.nci.nih.gov.1433 >
> dsl092-147-061.wdc1.dsl.speakeasy.net.4977: . ack 202 win 17320 (DF)
> 0x0000 4500 0028 3056 4000 6e06 e464 9c28 8653
> E..(0V@.n..d.(.S
> 0x0010 425c 933d 0599 1371 2e7d 27a3 b239 fea0
> B\.=...q.}'..9..
> 0x0020 5010 43a8 5412 0000 0000 0000 0000
> P.C.T.........
> 09:23:40.635077 mmdb2.nci.nih.gov.1433 >
> dsl092-147-061.wdc1.dsl.speakeasy.net.4977: F 442:442(0) ack
> 202 win 17320
> (DF)
> 0x0000 4500 0028 3057 4000 6e06 e463 9c28 8653
> E..(0W@.n..c.(.S
> 0x0010 425c 933d 0599 1371 2e7d 27a3 b239 fea0
> B\.=...q.}'..9..
> 0x0020 5011 43a8 5411 0000 0000 0000 0000
> P.C.T.........

??? some zeroes ???

> 09:23:40.635096 dsl092-147-061.wdc1.dsl.speakeasy.net.4977 >
> mmdb2.nci.nih.gov.1433: . ack 443 win 63799 (DF)
> 0x0000 4500 0028 427c 4000 8006 c03e 425c 933d
> E..(B|@....>B\.=
> 0x0010 9c28 8653 1371 0599 b239 fea0 2e7d 27a4
> .(.S.q...9...}'.
> 0x0020 5010 f937 9e81 0000 P..7....
>

No data

> Doesn't look like much. The real oddity is we should see
> "2a" come back
> from the server, because that's the value (42) of the output
> parameter.
> Here's my crude attempt to find TDS tokens (it's not meant to
> be smart,
> just helpful):
>

No cursor at all.

>
> That's as far as I'm going to get tonight.
>

Same problem. I should sleep more at nigth :)

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page