ODBC Based SQL query appears to be "throttled"

I'm pulling my hair out on this one...

I keep a Delphi 7 development at a client's site.  I have a SQL query tool  that  built in Delphi, using ODBC connection to Sybase and MS SQL.  It has worked flawlessly for years.

Just recently it is acting very weird - a query run with this program on the  D7 PC takes 40+ seconds (run against Sybase AND mssql, both slow).  Run using the same tool on any other PC and the query takes about 1/3 of a second...

If I copy the tool from the "bad" PC to a network drive, and run the tool from the shared drive on any other PC it works great (so it isn't the code).  I did a ghost of the  D7 PC, and applied it to a second PC (100% same hardware) - it still goes slow - so evidently not NIC or hardware related.

One thing - I installed "skype" (internet phone software) about two weeks ago.  I know skype throttles tcp/ip bandwidth usage for its own connections - maybe something bad went wrong there?  I uninstalled skype (and dug into registry to find pieces it didn't uninstall). I also ran Norton WinDoctor and cleaned up some old registry anomalies.

It still runs slow...

I need some suggestions of what to look for next - I'm stumped.  

Who is Participating?
PashaModConnect With a Mentor Commented:
Closed, 500 points refunded.
Community Support Moderator
edboredAuthor Commented:
Solved it.

I posted here because I suspected it was a network problem. Turns out a new SQL monitoring tool I installed turned on ODBC SQL Tracing behind the scenes. For some reason, it didn't restore the setting to stop logging when the SQL tool was closed (bad sql tool, bad!).

At any rate, every fetch from the sql engine was being logged - and THAT was taking 15 times as long as the normal SQL query...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.