Re: Waiting for a recordset to finish fetching

Are you sure? I got the impression that JET started to deliver rows before
the rowset population is complete. SQL Server does this too--it delivers
the first rows to ADO.NET (to the provider) when the first buffer is done.
These rows are streamed over in the DataReader as they are made available
on the server. No, JET is not SQL Server and JET's provider is very
different than SqlClient but I would not be surprised if JET started
making rows available before the last one was found--at least to the
DataReader (which is behind the scenes in ADO classic). If the application
tries to update the rows fetched, I have also seen JET open another
connection and start making changes.

Yes I am sure. This is ADO and not ADO.NET.

Server-sided => Open() will return early.
CacheSize records are populated and refilled once MoveNext() empties the
buffer.
Very database and provider-specific

Client-sided, synchronous => Open() will only return when the entire rowset
is in client-sided memory.
That is true for all providers.

Client-sided, asynchronous => Open() will return early and you can monitor
the progress watching Status as the rest of the records are fetched.

I am not sure how ADO.NET differs.
Maybe sometime I will play with DataReader's

Cheers

Stephen Howe


.

Relevant Pages

  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... Exception Details: System.Data.SqlClient.SqlException: A connection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: .NET data provider or OLEDB provider?
    ... >I don't see where you see a built-in query engine. ... >service provider, ... >OLE DB providers don't have to support SQL however, ... > SQL Server linked server, SQL Server can handle the queries. ...
    (microsoft.public.data.oledb)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... pipes and I have the server configured to connect using TCP/IP. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DMX cmd cant see Access db
    ... provider I'm trying to use in order to read data from an Access database. ... Dejan Sarka, SQL Server MVP ... (studentid, gender, iq,parentencouragement, parentincome, collegeplans) ... CollegePlans from CollegePlans') ...
    (microsoft.public.sqlserver.datamining)