Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

6 second connection delay

I've recently updated my system to XP service pack 3. I am now getting a problem when using Sql server 2000, which is running on a seperate machine.  Everytime I try to open a connection, whether through query analyzer, enterpirse or VB6 - I am getting a 6-8 second delay for the connection to open.  Very annoying.

Help please!
0
fenety
Asked:
fenety
1 Solution
 
Bill BachPresidentCommented:
Sounds like a DNS timeout issue.  Check the name of the database server by PINGing it after a fresh reboot (i.e. before accessing this server at all).  See if it takes a long time to resolve the name, too.

If it's something else, then a network analyzer would find it rather quickly.  Get Wireshark (www.wireshark.org) and take a network capture while you are experiencing the delay.  Post the PCAP file if you cannot see what might be wrong, and we can review it together.
0
 
fenetyAuthor Commented:
resolved
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now