Re: Microsoft Access and Multiple result sets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

> With ADO v1.1 you can return multiple result sets via a single DataReader.
> But is this possible if the database you are querying is Microsoft Access.
> I've tried SQL like "SELECT * FROM Orders WHERE ID = 4; SELECT * FROM
> OrderLines WHERE OrderID = 4" in the ADO Command, but this failed with the
> Jet OleDb provider for ADO.Net.
> Am I doing something wrong, or do I have to (try and) go back to using
SHAPE
> to get what I want?

IIRC, the Jet OleDb provider does not support multiple SQL commands.
They would have to be in a stored procedure.

Stephen Howe


.

Relevant Pages

  • Re: VB 6 and MS SQL Server 2000 - (Yudkin)
    ... Since you have multiple SELECT statement, ... If I need to use ADO, what components do I have to include in my project? ... GetClipString is an RDO API. ... SQL SP's have no concept of event flows. ...
    (microsoft.public.vb.general.discussion)
  • Re: commandBuilder Update SQL generation for > 1 table?
    ... > allow updates of ad-hoc queries in a data grid involving multiple ... In old school ado, you'd have a bitch of a time grabbing a ... recordset from SQL Server and having it elegantly created in excel. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO and Multithreading
    ... >I am devloping av program for merging PDF-files at specific times during the ... Multiple merges can occur at the same time and therefore I will use ... >I am also able to get access to the database using ADO and retreive data. ...
    (alt.comp.lang.borland-delphi)
  • Problems in Client/Server Implementation of an MFC application
    ... Can I make a general implementation by using ADO? ... Now I am using Multiple SQL queries for multiple table updations. ... But I think MySQL won't support transactions...Is there any other ...
    (microsoft.public.vc.mfc)
  • Re: Using ado to read extended field properties of a jet database?
    ... Is there a way using the jet oledb provider and ado to ... ADO contains no intrinsic DDL methods. ... "ADOX Programming Code Examples" ...
    (microsoft.public.data.ado)