How do I trace from my client PC what databases it connects to

Question

I wonder if there is some way to trace what servers my program using OLEDB tries to connect to.

Problem:

I have a program displaying some reports made in Crystal Reports. The loading of some reports are really slow when. My guess is that they have some embedded connection strings which reference a server that does not exist. My guess is that the client tries to use the embedded connections when loading the report.

I would like to know if I can see trace / log these failed connections in any way.

score 1 · Accepted Answer · answered Apr 03 '12 at 13:35

1

You can run a packet capturing application like wireshark (Linux + Windows) or tcpdump (Linux). If your server is busy, it may not be easy to recognize the relevant/irrelevant connections.

If you know the port number/protocol, you can write filters to see less traffic.

answered Apr 03 '12 at 13:35

Khaled

35,688
8
69
98

Wiresharke gives me a lot of these: 7 0.008877 10.0.2.15 10.0.2.255 NBNS 92 Name query NB SERVERX<00> The SERVERX is no longer existing but there are about 100 such NBNS queries – mortb Apr 04 '12 at 08:55

score 1 · Answer 2 · answered Apr 03 '12 at 13:36

1

you could try to :

netstat -a and see which connections your trying to make
odbcad32.exe or variant to see which connections you have configured .For Windows 2003: %systemdrive%\SysWoW64\Odbcad32.exe or run it from Start\Run

answered Apr 03 '12 at 13:36

Alex H

1,814
11
18

score 0 · Answer 3 · edited Apr 05 '12 at 15:38

0

arp -a

Is another method for figuring out who you are connected to.

edited Apr 05 '12 at 15:38

jscott

24,204
8
77
99

answered Apr 03 '12 at 13:42

J Baron

338
1
7

How do I trace from my client PC what databases it connects to

3 Answers3