Re: How do I do multiple asynchronous ADO connections ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Collier (noemail_at_noemail)
Date: 02/05/04 

Date: Thu, 5 Feb 2004 05:19:31 -0000

> >> So, how do I do multiple asynchronous commands ? I can't open a new
> >> connection for each command (can I ?)

I managed to track down an old example of asynchronous ADO tasks (written in
Delphi though).

The example uses Threads. Each thread opens its own connection (which is a
point you were alluding to earlier).

It looks like multiple connections are the way to go in your situation. I
didn't have much luck trying to use a single connection object for this.
Though I don't think you need to go as far as creating your own threads.

Let me know if you need any more details. 

-- 
Mike Collier
FREE ADO Inspector tool when you register at ADO forum.
www.adoanywhere.com
http://www.adoanywhere.com/forum

Relevant Pages

  • Hope springs eternal...
    ... ORACLE to the ADO component ... greater value doesn't translate very well in Delphi. ... you can specify the connection information on a Command item. ...
    (borland.public.delphi.database.ado)
  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: How to make the app run?????
    ... throwing an error if the connection never was opened, ... How can i tell if i'm using ADO as in VB or .Net ADO ?? ... First of all, it was not shown to my customer, I took it to a very nice ... How do you get in "installed" on client computer? ...
    (microsoft.public.dotnet.general)