March 1, 2004 at 1:58 pm
Hi Group -
I have a VB5 app that runs in the IDE (don't ask) and accesses a SQL Sever 2K database.
I believe the app is using the ole db provider for odbc NOT the native provider for sql server. Every so often the app hangs on a unhandled error msg box saying
'ODBC Link Communications Error' (or words to that effect).
When I press the Debug it takes me to an ADO connection Execute method (with a simple select on one of the tables). This VB5 app is somewhat timer driven (it's polling the PLCs of several knit machines in order to store stuff in sql server tables).
My guess is that a SQLAgent job (run on Sunday) is causing a blocking problem (it has one step with a whole bunch of DELETEs to periodically purge old data from several tables in the same db used by the vb app).
Finally, my question: Is my guess a good one and if so, can I set up some sort of a Profile trace to prove this is a blocking problem (if so how to I define the Profile??).
Sorry if this ? is too basic, but I'm just getting my feet wet in sql server.
Thanks a lot Group.
Mike At The Mill
Mike at the Mill
March 1, 2004 at 2:23 pm
There are several good scripts here to help with blocking problems. I've used this one http://www.sqlservercentral.com/scripts/contributions/407.asp
Also Microsoft has a good proc called 'sp_blocker_pss80.' see http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
Francis
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply