Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

PRB: Access ODBC Driver Does Not Support Multiple Result Sets


View products that this article applies to.

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.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


References

Microsoft Jet Database Engine Programmer's Guide

↑ Back to the top


Keywords: kbdatabase, kbmdacnosweep, kbprb, KB202433

↑ Back to the top

Article Info
Article ID : 202433
Revision : 3
Created on : 9/17/2003
Published on : 9/17/2003
Exists online : False
Views : 443