MDAC 2.5 SDK - OLE DB Providers
OLE DB Persistence Provider
ADO and OLE DB developers wanting to save the results of a query to a local file for later viewing or modification can use the OLE DB Persistence Provider. The functionality of this provider can be exposed using ActiveX® Data Objects (ADO).
The OLE DB Persistence Provider allows you to save rowset data obtained from a data store, its accompanying metadata describing the columns of the rowset, and the rowset's state to a local file. Once saved, the data can be accessed later without reconnecting to the original data store.
Currently, the two formats allowed are Advanced Data Tablegram (ADTG) and an Extensible Markup Language (XML) representation of the underlying rowset. ADTG is the binary format used to remote rowsets by Remote Data Service (RDS), where the XML representation is Microsoft's XML schema for OLE DB rowsets based on the ASCII standard.
Rowset persistence is possible with the Microsoft® Data Access Components version 2.0 and later, which includes OLE DB, Microsoft ActiveX Data Objects (ADO), and Remote Data Service (RDS). The service provider, the OLE DB Persistence Provider, is a service component that interacts with your OLE DB data provider and your data consumer. When coupled with other OLE DB service components, such as the Cursor Service or Remoting Provider, the result set gains functionality otherwise unavailable, allowing you to view or modify the disconnected rowset data as a recordset and update the original data store if desired.