Re: asychronous OLEDB

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

Thanks for the reply.
However, I already read that reference before. I did quite a bit of search
and looked at several books before I posted and seem that nobody has ever
used OLEDB asynchronously.

Somehow I do not feel confident to use features of a technology that has no
sample neither a extensive doc. I can't base the foundation of my data access
to some personal assumption on how OLEDB works.

About the ODBC, I have to look into it, but I have a full OLEDB
driver/marshaller for my app platform I hoped I could avoid rewriting/retest
the whole thing.

Any MS guy around here that knows about some OLEDB async sample?

thanks for your time
Alberto Demichelis

"Erland Sommarskog" wrote:

Alberto Demichelis (AlbertoDemichelis@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
My questions are:
Is it possible to perform sn asychronous query? (I guess so I read
about it but found no sample)

Yes. This is a starting point:
http://msdn2.microsoft.com/en-us/library/ms724368.aspx

I have not worked with it myself, nor do I know of any samples.

Is it possible to be sure that resulting the recordset of a select is
alredy filled? (in the context of an asychronous query)

Not sure what you mean, but it appears that the way the consumer that
there is data to retrieve is by polling. As I understood it, you may find
a rowset that is not yet complete.

Alternatives to OLEDB?

ODBC is probably an interface that is easier to work with from a language
like C++, and ODBC also has asynchronous support. I have not used ODBC
that much myself, though.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Really want a answer, is there a mature way to access different data providers without performan
    ... I dll can support both SQL server and mysql, ... > You can use OleDB and ODBC also. ... > direct adapter as SqlClient. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Mail merge] Pb with a datasource from a remote server
    ... > still uses ODBC to connect to SQL Server databases, ... >>> Are you using OLEDB or ODBC to connect? ... >>> Are you using WIndows Integrated Security or SQL Server security? ... >>> Peter Jamieson ...
    (microsoft.public.word.mailmerge.fields)
  • Re: datetime type in SQL Server 2008
    ... You're using ODBC to connect to SQL Server 2008...? ... ..NET data providers to replace OleDb and didn't even include ODBC natively, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Components - SQL Server Compact Edition?
    ... or any components that work with OLEDB or ODBC. ... Vassiliev V. V. ... to connect to SQL Server 2005 Compact Edition? ...
    (borland.public.delphi.database.ado)
  • Re: Migrating to OLEDB
    ... Certainly OLE DB is extremely flexible and I certainly understand that the ... in making a decision to use OLE DB over ODBC for a "typical" application. ... I am presently grappling with problems with OLEDB in our own application (an ... request a Forward-Only, Static, Keyset Driven, or Dynamic cursor type ...
    (microsoft.public.data.odbc)