Determining the amount of network traffic

When I run a query or open a table, it would be nice (during
development time) to see exactly how much data is being forced over
the wire. I am using Delphi 2005, Pro. Using dbGo ADO components.
Does anyone have a clever debug method to see exactly what is the
repercussions of different settings (i.e. client side cursor v. server
side, etc.)

thanks
jamie

Messages in this topic (1) Reply (via web post) | Start a new topic

.

Jamie L. Mitchell wrote:
> When I run a query or open a table, it would be nice (during
> development time) to see exactly how much data is being forced over
>; the wire. I am using Delphi 2005, Pro. Using dbGo ADO components.
> Does anyone have a clever debug method to see exactly what is the
> repercussions of different settings (i.e. client side cursor v. server
> side, etc.)

Have you tried Ethereal? It's a free tool for observing network traffic.
You can limit it by port, address, and protocol so you're not
overwhelmed by traffic unrelated to your program.

--
Rob

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Rob Kennedy wrote:
> Jamie L. Mitchell wrote:
>> When I run a query or open a table, it would be nice (during
>> development time) to see exactly how much data is being forced over
>;> the wire. I am using Delphi 2005, Pro. Using dbGo ADO components.
>>; Does anyone have a clever debug method to see exactly what is the
>> repercussions of different settings (i.e. client side cursor v. server
>> side, etc.)
>
> Have you tried Ethereal? It's a free tool for observing network traffic.
> You can limit it by port, address, and protocol so you're not
> overwhelmed by traffic unrelated to your program.

I second Ethereal. The GUI is slightly cumbersome to use (they really
need a wizard for those who only use it occasionally), but will show you
every last bit of traffic. Won't really work properly if you are trying
to figure out data traveling over VPN (found that out recently - it made
complete sense but resulted in one of those enlightening 'duh' moments).

--
Thomas Hruska
CubicleSoft President
Ph: 517-803-4197

*NEW* VerifyMyPC 2.5
Change tracking and management tool.
Reduce tech. support times from 2 hours to 5 minutes.

http://www.CubicleSoft.com/VerifyMyPC/

Messages in this topic (0) Reply (via web post) | Start a new topic

.

Hi All

Can you guide me in creating a sql server Database using ADOX in delphi,


Thanks
Mahesh


---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.

[Non-text portions of this message have been removed]

Messages in this topic (0) Reply (via web post) | Start a new topic

.