Re: ADO and too many Handles



I had a similar issue some time ago. Found out that it was a known bug in
ADO. Since then I don't remember how to correct. This rings a bell, but I
don't have any more comments about this.

> 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.

.



Relevant Pages

  • 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: 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)
  • update a primarykey-value
    ... I want to update a value which is in a primary key column. ... I am using ADO ... on SQLServer 2000. ... Sebastian Raemsch ...
    (microsoft.public.vb.database.ado)
  • Re: Identity error?? Please help
    ... >> each table has an identity column. ... > It sounds like you've run up against the ADO bug of the year... ... Use GUIDs in place of IDENTITY ...
    (borland.public.delphi.database.ado)