prssible bug in oleDbDataAdapter

[Luigi]

Hi,
I've written a Stored procedure that return 3 different tables. Something
like:
Select * from A;
Select * from B;
Select * from C;

But when I try to retrive the datas in a dataset,
only the first table is filled.
The code I use is like this

DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(oleDbCommand);
da.tableMappings("Table", "A");
da.tableMappings("Table2", "B");
da.tableMappings("Table3", "C");
da.Fill(ds);

Did somebody had the same problem?

Tnahks

 

[William Ryan eMVP]

Does your database support batched queries? If you are using access (I
noticed the Oledb library) I don't think it does and that's probaby the
problem.