OleDB do not support dataReader.NextResult?

  • Thread starter Thread starter Rabbit
  • Start date Start date
R

Rabbit

Hi,

Has anyone try to use NextResult method of DataReader for retrieving
multiple sql statements in one query?

Besides this method works for SQL Server, I'm using MS Access as database,
seems this method doesn't work, am I right that Access database do not
support this feature?

Thanks
Keith
 
Rabbit:

Access doesn't support Batched Queries the last time I checked (or most
anythign else useful ;-)). However, the OleDbDataReader doesn't only work
with access and AFAIK, as long as the DB supports batch queries, the
datareader will be good to go. You won't be able to send batches with
DataAdapter.Fill either using access but if the db does allow it you're
fine. I just tried accessing SQL Server with OleDbClient instead of
SqlClient and it works.

Probably a good time to trade in headaches (access) for a better and cheaper
DB (SQL Server MSDE)

HTH,

Bill
 
Back
Top