ADO Express losing handles

This is more or less of an FYI.

I'm using BCB5 and ADO Express. But, that group is about as
close to dead as it can get. I figured I'd have more visibility
here ;-)

We have a service application. It runs forever. It sleeps and
then wakes up every minute looking for work to do. It creates a
couple of TADOConnection objects, connects them, looks for work
(TADOQuery), closes and then deletes them and goes back to sleep.

Every time TADOConnection::Open() is called, two unnamed
semaphores are created. They are never deleted. After running
for a few weeks - well you get the idea. The service has a LOT
of open handles. Things on the server go down hill from there.

We are in the process of porting our server side apps to VC++ (
no more ADO) and the service just bubbled up to the top of the
list. I'm working on that now. It resolves the problem.

As I said, this is an FYI. If any of you are using a service app
that periodically opens and closes ADO Connections, use task
manager to see how handles your service is using.

- Arnie


.

Relevant Pages

  • Re: SQL Server extremely slow
    ... terms of what is meant by a dis-connected ado recordset. ... table in a mdb file could be considered disconnected from the server ... Well, ok, but keep in mind the disk drive is on sql server! ... 10 reocrds from the server via odbc does not produce more ...
    (comp.databases.ms-access)
  • Re: Variable in SQL Where Statement in =?windows-1252?Q?=93Pass_?= =?windows-1252?Q?__Throug
    ... to a server, either. ... Well, when using ADO, we can indeed bind the resultset of stored procedure to a form and still have it updatable, providing we follow same set of rules we have to follow for writing queries for a form's recordsource. ... It's only in the case where you've bound a form to ADO recordset would you get a ADO recordset from the form's recordset. ... I actually never though to overlay a parameter query on top of a passthrough query, but that's two objects for one function, and I'm loath to create several objects. ...
    (microsoft.public.access.modulesdaovba)
  • Re: CHANGING from DAO to RDO
    ... To boost the speed we use Terminal Server 2003 and it definetly helps on the fact that we get less corruption, but certain queries take awhile and we want to add more users. ... I don't know _where_ you got the idea that ADO and RDO were the only methods to access SQL Server. ... In fact, I have never heard of anyone using RDO with an Access database, only, in the past, with the separate VB product. ... The VB crowd abandoned it for ADO with SQL Server, even though they, too, could use DAO and, for them too, DAO was simpler and easier. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Moving data back and forth between Excel and SQL Server
    ... your database you should look into using ADO. ... ADO proides an object model to let you work with data via SQL/ODBC. ... records, or to update/add records, or even to create or modify tables - all ... MyRs.Update ' updates recordset on server ...
    (microsoft.public.excel.programming)
  • Re: Error -2147168227 Cannot create new transaction because capacity was exceeded.
    ... OLEDB provider for SQL Server. ... > I have been unable to find info in the Knowledge base, ADO or SQL Server ... > ADO driver generates the error. ...
    (microsoft.public.data.ado)