Re: AsyncExecute blocks new connection on Connect:=True

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 10:56:14 +0300

ADO always uses OLEDB provider as back-end (except the case of in-memory
recordset). Here there is only one OLEDB provider - you name it ODBC-bridge,
actually it is OLEDB provider for ODBC data sources.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Kjell Rilbe" <krilbe.sp@mblock.home.se> ???????/???????? ? ????????
?????????: news:421d86fd$1@newsgroups.borland.com...
> Brian Bushay TeamB wrote:
>
>>>The problem is that as long as query1 is still executing, I can't start
>>>query2. Is this a limitation in Delphi's ADO components, ADO itself or
>>>the specific ADO driver (ODBC-bridge + Firebird ODBC driver)? Or is it a
>>>bug in there? Or am I doing something wrong?
>>
>> The problem should be in the OleDb provider
>
> What OLS DB provider? ADO + ODBC bridge + Firebird ODBC driver. Where does
> OLE DB come into it? (Note: I'm not aware what the relation between ADO
> and OLE DB is. I think I know about ADO vs. ODBC though. Feel free to
> enlighten me. :-)
>
> Thanks,
> Kjell
> --
> ---------------------------------------------------------------------------
> Kjell Rilbe
> Home: +46 8 7610734
> Cell: +46 733 442464
> ---------------------------------------------------------------------------
> "If there's a price for bein' me, that's one I'll have to pay"
> Aaron Tippin
> ---------------------------------------------------------------------------

Relevant Pages

  • Re: ADO call to user defined function
    ... support all the features, which supported by OLEDB. ... OLEDB provider for SQL ... Server was developed some time ago, when SQL Server did not have UDF's. ... is why ADO does not support them as well. ...
    (microsoft.public.data.ado)
  • Re: ADO vs DAO
    ... DAO was designed for Access and uses all the advantages of it. ... Actually ADO does not add any additional layer if you use it correctly. ... because ADO has to use OLEDB provider and does not work with ODBC directly. ... a light version of SQL Server, is free and has same functionality as SQL ...
    (microsoft.public.vb.database.ado)
  • Re: Thread View
    ... Yes, ADO creates additional threads. ... Also OLEDB provider may create threads. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: create ODBC or ADO driver
    ... For ADO you need to write OLEDB provider. ... > Now I want to create the ODBC or ADO driver with same functionality. ... > With best regards, Mike Shkolnik ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: AsyncExecute blocks new connection on Connect:=True
    ... Is this a limitation in Delphi's ADO components, ... > The problem should be in the OleDb provider ... ADO + ODBC bridge + Firebird ODBC driver. ... ADO and OLE DB is. ...
    (borland.public.delphi.database.ado)