Using an Existing ADO Recordset
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

Using an Existing ADO Recordset

To mix OLE DB consumer templates and Active Data Objects (ADO), use ADO to open a recordset (corresponding to a rowset in the OLE DB Consumer Templates). Once you have a recordset, do the following to connect to an OLE DB rowset:

  1. Call QueryInterface for the IRowset and IAccessor pointers.
    IRowset* lpRowset = NULL;
    IAccessor* lpAccessor = NULL;
    lpUnk->QueryInterface(IID_IRowset, (void**)&lpRowset);
    lpUnk->QueryInterface(IID_IAccessor, (void**)&lpAccessor);
    Note   lpUnk points to the IUnknown object of the ADO recordset.
  2. Attach the accessor and rowset to their appropriate OLE DB consumer template classes.
    CRowset rs;
    CAccessor accessor;
    accessor.AddAccessorInfo(0ul);      // 0 is the ordinal of an ADO accessor
    rs.m_spRowset.Attach(lpRowset);      // use the Attach method of CComPtr<>

See Also

Using Accessors

© 2016 Microsoft