C++ Example of OCI Dataset

void CMapXView::OnOCI() {
 CMapXDataset ds;
 CMapXOCIQueryInfo parm;
 COleVariant parmVt;

 try {
  // Create a new OCIQueryInfo object
  parm.CreateDispatch(parm.GetClsid());

  parm.SetSqlQuery("select * from USA");
  parm.SetConnectString("SRVR=ontario;UID=mapx;PWD=mapx"

  // Set the variant parmVt to point to our OCIQueryInfo
  // object.
  parmVt.vt = VT_DISPATCH;
  parmVt.pdispVal = parm.m_lpDispatch;
  parmVt.pdispVal->AddRef();

  // Add the Dataset.

  ds = m_ctrlMapX.GetDatasets().Add(miDataSetOCI, parmVt, "Oracle Dataset");

  // Create the default theme on the dataset
  ds.GetThemes().Add(COptionalVariant(), COptionalVariant(), COptionalVariant());
 } catch (COleDispatchException *e) {
  e->ReportError();
  e->Delete();
 } catch (COleException *e) {
  e->ReportError();
  e->Delete();
 }
}