OleDB do not support dataReader.NextResult?

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
 
W

William Ryan eMVP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top