NextResult with OleDB and Access 2000

when I try to open a DataReader with a batch SQL like:
Select * from customers; Select * from providers;
or
Select * from customers Select * from providers

on an Access 2000 DB using de following Con. String:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\tmp\prueba.mdb

I get an Incorect Sintax Error.

It works fine on a SQL DB
How can I solve this problem with an Access DB.

Miha
Fri Feb 06 08:32:03 CST 2004

Hi Eric,

AFAIK batch read is not supported for Access

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Eric" <eric@programalia.com> wrote in message
news:OrkPE7K7DHA.2404@TK2MSFTNGP11.phx.gbl...
> when I try to open a DataReader with a batch SQL like:
> Select * from customers; Select * from providers;
> or
> Select * from customers Select * from providers
>
> on an Access 2000 DB using de following Con. String:
>
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\tmp\prueba.mdb
>
> I get an Incorect Sintax Error.
>
> It works fine on a SQL DB
> How can I solve this problem with an Access DB.
>
>