Hi. I am trying to use WireShark (WS) to monitor traffic between client and server, on the same machine. The application talks to sqla through an odbc dsn, set for tcpip on port 2638. WS reports a blizzard of traffic, even before I start sqla. When I start sqla, the same inscrutable blizzard just continues. When I set WS to report only traffic on port 2638, the traffic screen goes blank. I want to use a packet monitor to observe packet traffic between sqla client and server, when sqla is running with different encryption settings. Any thoughts/suggestions appreciated. Thanks.

asked 21 Apr '12, 13:21

dejstone's gravatar image

dejstone
959405069
accept rate: 0%

Just two guesses:

  • Are you sure the connection is using TCP/IP at all (and not shared memory, as would be typical for same-box communication)?

  • What happens when you monitor the client port (as specified by sa_conn_info()) instead of the server port (2638 by default)?

(21 Apr '12, 14:25) Volker Barth

My experience with WireShark on Windows is that local machine TCP/IP traffic is not captured by WireShark. In order to capture packets with WireShark, I needed to make sure the client and server were on different machines.

permanent link

answered 23 Apr '12, 08:57

Ian%20McHardy's gravatar image

Ian McHardy
3.1k23354
accept rate: 38%

edited 23 Apr '12, 08:57

There is a tool called RawCap that apparently does work for same-machine connections. I have never used it myself, but at least one person here has, and it seems to work well.

(23 Apr '12, 09:12) Graeme Perrow

To be sure you're using tcpip, start the db engine from the run command something like this

dbsrvX -x tcpip -n engineName c:\database\x.db

When you set up your ODBC connection, on the database tab enter engineName in the server name field, leave all of the other fields blank EXCEPT the encryption key, and on the network tab check TCPIP and uncheck Shared memory.

permanent link

answered 22 Apr '12, 12:15

Tom%20Mangano's gravatar image

Tom Mangano
632202636
accept rate: 6%

edited 23 Apr '12, 08:36

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275

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:

×34

question asked: 21 Apr '12, 13:21

question was seen: 1,642 times

last updated: 23 Apr '12, 09:12