🚀 go-pugleaf

The following piece of code (a Transactional Object)
works fine when it isn't the component isn't added to a COM+ application.

When added, the changes made to the database through updatebatch
aren't committed.

Does anybody have a clue how this comes ?
It would help me a lot.

When i look at the statistics of COM+ it appears as if the transaction succeeded.

--------- CODE : ------------
STDMETHODIMP TTYRAImpl::ReturnRS(LPDISPATCH* Rs)
{
  try
  {
    TCOM_Recordset adoRs = CoRecordset::Create();
    adoRs->CursorLocation = adUseClient;
    adoRs->Open( "SELECT * FROM Customers", "DSN=North", adOpenStatic,
      adLockBatchOptimistic, adCmdText );
    *Rs = (IDispatch*)adoRs;
    adoRs->AddRef();
    return S_OK;
  }
  catch (...)
  {
    ShowMessage("Return Problem !");
  }
  return E_FAIL;
}


STDMETHODIMP TTYRAImpl::UpdateRs(LPDISPATCH Rs)
{
  _Recordset* rs;
  try
  {
      Rs->QueryInterface(__uuidof(Recordset), (void**)&rs);

      TCOM_Connection cn = CoConnection::Create();
      cn->ConnectionString = L"DSN=North";
      cn->CursorLocation = adUseClient;
      cn->Open(L"", L"", L"", -1);
      rs->ActiveConnection = cn;
      rs->UpdateBatch(adAffectAll);
      rs->Release();
      m_spObjectContext->SetComplete();
  }
  catch(...)
  {
    ShowMessage("Update Problem !");
    m_spObjectContext->SetAbort();
  }
  return S_OK;
}

Micha�lo Lesage.