PRB: Access ODBC Driver Does Not Support Multiple Result Sets (202433)
The information in this article applies to:
- Microsoft Data Access Components 1.5
- Microsoft Data Access Components 2.0
- Microsoft Data Access Components 2.1
- Microsoft Data Access Components 2.5
- Microsoft ODBC Driver for Access 4.0
- Microsoft ODBC Driver for Access 1.0
- Microsoft ODBC Driver for Access 2.0
- Microsoft ODBC Driver for Access 3.0
- Microsoft ODBC Driver for Access 3.5
- Microsoft ODBC Driver for Access 3.6
This article was previously published under Q202433 SYMPTOMS
The Microsoft Access ODBC Driver does not support multiple result sets of native Access tables. Calling SQLGetInfo( hdbc, SQL_MULT_RESULT_SET, ... ) returns an 'N' signifying the driver does not support multiple result sets. This means an application cannot call the ActiveX Data Objects (ADO) ADODB.Recordset.NextRecordset method when using the Microsoft OLE DB Provider for ODBC Drivers and the Microsoft Access ODBC Driver.
Calling the NextRecordset method returns error 800A0CB3:
The operation requested by the application is not supported by the provider.
Do not use the ADODB.Recordset.NextRecordset method with the Microsoft Access ODBC Driver or any other driver that does not support multiple result sets.
STATUS
This behavior is by design.
REFERENCES
Microsoft Jet Database Engine Programmer's Guide
| Modification Type: | Major | Last Reviewed: | 9/17/2003 |
|---|
| Keywords: | kbDatabase kbMDACNoSweep kbprb KB202433 kbAudDeveloper |
|---|
|