Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

3 Answers 3

up vote 1 down vote accepted

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.

share|improve this answer
    
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 4 '12 at 8:55

you could try to :

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

arp -a

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.