Re: asychronous OLEDB

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: UPDATE query gives Incorrect Syntax error
    ... LastUpdated, allows nulls) ... My VB application connects via ODBC no problems. ... Restarting SQL Server does not fix the problem nor does rebooting the ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Grant v Deny
    ... connected using ODBC and ACCESS to link the table that couldn't make any ... Could not use view or function because of binding errors ... The only hint I can give an SQL Server person, is to set up a Profiler ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Assign permissions to allow updates but deny select on table
    ... when I run the delete query from MS Access 2003 is: ... ODBC --call failed. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: SQLDMO.Bulkcopy diagnostics on failed load
    ... ODBC error raised that complains about the violated NOT NULL ... You could set the batchsize to 1, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)