ADO and too many Handles

Hey,

I have a problem with the amount of handles created during execution of
a SQLServer 2003 and two programs using ADO.

I have one program that reads while the other writes. What has been
seen is the program writing is creating many handles dealing with
synchronization, SQLServer Mutex and SQLServer Share while the reader
is not. Obviously ones trying to write while the other is reading and
the writer is blocked.

They accumulate to the point where the program stops responding and it
has to be restarted. Can anyone think of a possible reason? I have
looked in the code to find if there is a property that sets this, but I
am having no luck.

Thanks for the help,

Mike

.

Relevant Pages

  • Re: ADO and too many Handles
    ... Found out that it was a known bug in ... > a SQLServer 2003 and two programs using ADO. ... > the writer is blocked. ...
    (microsoft.public.data.ado)
  • Date delimiter
    ... not with the Jet engine ... I would have thought that ADO would take care of such differences, ... all, ADO, Jet and SQLserver are all Microsoft products.... ...
    (microsoft.public.vb.database.ado)
  • Re: Network Traffic
    ... "Louis Wildschut" wrote in message ... > amount of data i receive from sqlserver. ... > Is there a simple calculation? ...
    (microsoft.public.sqlserver)
  • Re: Alternative zu Fox Pro gefunden Erfahrungsbericht
    ... Du kannst mit ADO bzw SQLServer genauso ein Netzwerk dicht machen wie mit VFP. ... Und du kannst mit VFP mit weniger Datentransport und 10x schneller nen Einzelsatz lesen als mit SQLServe. ...
    (microsoft.public.de.fox)
  • ADOSQLServerTransactions
    ... I am using Delphi 7, SQLServer 2000, and ADO ... I use the ADODatasets in the application to select, insert, update and ...
    (borland.public.delphi.database.ado)