Creating a Consumer Without Using a Wizard

The following example assumes that you're adding OLE DB consumer support to an existing ATL project. If you want to add OLE DB consumer support to an MFC application, you should run the MFC Application Wizard, which creates all the support necessary and invokes MFC routines necessary to execute the application.

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

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

  #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:

1. 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:

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

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

  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):

  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:

  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 called in the main code.

  CoUninitialize();
  

See also

Creating an OLE DB Consumer