This is our old Q&A Site. Please post any new questions and answers at ask.wireshark.org.

Hi,

I want to convert a TDS stream to clear-text or similar. Does anyone have a hint how to solve this?

/Stef

asked 26 Jun '11, 01:48

stefan741's gravatar image

stefan741
1111
accept rate: 0%


When I view SQL data, which is transmitted via TDS, (Tabular Data Stream protocol), I am able to view the text by 1st selecting the Stream, (right click on one of the packets in the stream, then "Follow TCP Stream", then select "Hex Dump" as the format option in the bottom right of the TCP Stream window. The TCP Stream window includes hexidecimal data and on the right shows the text conversion of the data as you scroll down.

Hope this is helpful,

permanent link

answered 27 Jun '11, 04:50

John_Modlin's gravatar image

John_Modlin
1205
accept rate: 0%

Okay, thats what I got too (I guess). But it actually still seems to be a mess. I would like to extract either just the table content or some kind of structured output (tables + content).

(27 Jun '11, 06:16) stefan741

While not completely formatted, you can use use the TDS display filter, then Edit Menu, Mark All Displayed Packets, then File | Print, Output to File, Packet Format: "Packet Bytes" only, deselect Packet Summary line and Packet details. This will create a text file without the summary header information, only the bytes. This still isn't columnized like SQL records. LUA might be helpful, but I haven't played that much with LUA to advise more.

Hope this helps some,

permanent link

answered 27 Jun '11, 07:47

John_Modlin's gravatar image

John_Modlin
1205
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×752
×10
×2
×1

question asked: 26 Jun '11, 01:48

question was seen: 10,285 times

last updated: 27 Jun '11, 07:47

p​o​w​e​r​e​d by O​S​Q​A