To add OLE DB consumer support without using the ATL OLE DB Consumer Wizard:

• In your Stdafx.h file, append the following #include statements:

  В	Copy Code
  #include <atlbase.h> #include <atldbcli.h> #include <atldbsch.h> // if you are using schema templates

Programmatically, a consumer typically performs the following sequence of operations:

• Create a user record class that binds columns to local variables. In this example, CMyTableNameAccessor is the user record class (see User Records). This class contains the column map and parameter map. Declare a data member in the user record class for each field you specify in your column map; for each of these data members, also declare a status data member and a length data member. For more information, see Field Status Data Members in Wizard-Generated Accessors.

  Note
  If you write your own consumer, the data variables must come before the status and length variables.

• Instantiate a data source and a session. Decide what type of accessor and rowset to use and then instantiate a rowset using CCommand or CTable:

  В	Copy Code
  CDataSource ds; CSession ss; class CMyTableName : public CCommand<CAccessor<CMyTableNameAccessor> >

• Call CoInitialize to initialize COM. This is usually called in the main code. For example:

  В	Copy Code
  HRESULT hr = CoInitialize(NULL);

• Call CDataSource::Open or one of its variations.

• Open a connection to the data source, open the session, and open and initialize the rowset (and if a command, also execute it):

  В	Copy Code
  hr = ds.Open(); hr = ss.Open(ds); hr = rs.Open(); // (Open also executes the command)

• Optionally, set rowset properties using CDBPropSet::AddProperty and pass them as a parameter to rs.Open. For an example of how this is done, see GetRowsetProperties in Consumer Wizard-Generated Methods.

• You can now use the rowset to retrieve/manipulate the data.

• When your application is done, close the connection, session, and rowset:

  В	Copy Code
  rs.Close(); ss.Close(); ds.Close();

  If you are using a command, you might want to call ReleaseCommand after Close. The code example in CCommand::Close shows how to call Close and ReleaseCommand.

• Call CoUnInitialize to uninitialize COM. This is usually called in the main code.

  В	Copy Code
  CoUninitialize();