Re: Microsoft Access and Multiple result sets

Tech-Archive recommends: Speed Up your PC by fixing your registry

> Do you know where I can get absolute confirmation of this and any other
> limitations of using Access with ADO v1.1?
> Also your comment about needing a stored procedure isn't correct.

Yes it is.
I am talking specifically about the limitations of the Jet Provider.
I am not talking about other providers.
TTBOMK, Jet Provider does not allow this.

> With SQL Server I can retrieve multiple results using either a stored
procedure or
> text.

Right. But that is a function of SQLOLEDB provider - it can process multiple
text commands.
The SQLOLEDB provider is the one I am most familiar with - I use it every
day.
The Jet OLEDB provider can not do the above.

> Or do you mean that it would need to be POSSIBLE to put them in a
> stored procedure and you can't do that in Access.

That I am uncertain about. You can run Access queries.
I do not know if Access queries can return multiple rowsets.
It may well be that it is as limited as issuing commands via text.
A quick experiment would verify this.

Cheers

Stephen


.

Relevant Pages

  • Re: NHibernate or LINQ to SQL?
    ... use any provider-specific facilities for mapping. ... IQueryable which contains the provider. ... without minding the limitations of a specific provider (which kills the ... genericity right on the spot), what's the real difference, aside from the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: nVarchar limitations using OLEDB provider
    ... There are no such limitations. ... João Paulo Figueira ... Device Application Development MVP ... When I use the Microsoft.SQLSERVER.MOBILE.OLEDB3.0 provider to connect ...
    (microsoft.public.sqlserver.ce)
  • Re: Re: ADODC1 and ADODC3 PROVIDER CANNOT BE FOUND ERROR [multiposted]
    ... 5th) Runtime error '91' - Object variable or With block variable not ... may cause multiple people to respond to your ... an access 97 Dahe database! ... Provider cannot vbe found. ...
    (microsoft.public.vb.database.ado)
  • Re: Problem changing password using ADOX.Catalog.Users(User).ChangePassword
    ... Maybe some difference in security settings? ... Do you have same service packs for the Jet provider? ... > support the administration of trustee properties? ...
    (microsoft.public.data.ado)
  • Received doc with changes showing
    ... We received a document from an outside source and the tracked changes all ... The provider said that she has sent the same document to multiple ... parties and no one else can see the changes. ...
    (microsoft.public.word.docmanagement)