Re: Problem with ATL/COM

Hello

I use a C# asp.net webbapplication which call different COM object using the
defined COM interface for each concrete C++ class.
So at the bottom I have OpenDS method located in the concrete C++ class
CHandle_DS.
This method is also define at the IHandle_DS COM interface.
Here is the sequence for the code.
1. I create a concrete C++ class from C# asp.net like this
   CHande_DS handle_ds = new Handle_DS();
2. I call OpenDS like this
  handle_ds.OpenDS();
3. I pass this concrete C++ object into a method called InitRules2 which is
defined in the COM interface ISyntaxObj
You can see below I have listed a piece of InitRules2.
4. I store the passed pointer to IHandle_DS in another class called
CAlterObj.
5. The first method to be called from InitRules2 is DBInitCommandTemplate
6. If you now look at method DBInitCommandTemplate below you can see that I
use the local Session and local DS in the previous code in several places
but in the new code I can't use the local Session because of the new
functionality.
I must in some way use the CSession object that is stored in the concrete
C++ class CHandle_DS but that is not easy because of the COM interface
IHandle_DS.

The reason for storing this CDataSource and CSession in CHandel_DS is to
keep the database open until I close it at the end of C# asp.net. So I have to drag this
CHandle_DS object from C# asp.net into the InitRules2 because of keeping
the status of my connection to the database.

So can you give me some piece of advice how to modify or create a new interface so I
can access the object Session in method DBInitCommandTemplate see below and
LoadProcedureRules below.

Note in especially that I only use the object Session in both DBInitCommandTemplate and
LoadProcedureRules.

STDMETHODIMP CSyntaxObj::InitRules2(IHandle_DS* handle_ds, BSTR Provider,
BSTR DataSource, BSTR UserId, BSTR Password, BSTR ProductID, BSTR Revision,
           BSTR ApplicationID, BSTR ApplicationRev, BSTR SubfileID,
VARIANT_BOOL *bRes)
{
  m_pAltObj = new CAlterObj;
  m_pAltObj->m_handle_DS = handle_ds;
  m_pAltObj->DBInitCommandTemplate(some parameter here)))
}

HRESULT CAlterObj::DBInitCommandTemplate(some parameter here)
{
...
CCommand<CAccessor<CSetRole> > sqlRole;
//CSession Session; // old code
//CDataSource DS; // old code
//hr = DS.Open(); // old code
//hr = Session.Open(DS); // old code
  hr = sqlRole.Open(Session);
  hr = LoadProcedureRules(&Session,&dbPropSet,ProductID, Revision,
SubfileID);
...
}

STDMETHODIMP Handle_DS::OpenDS(VARIANT_BOOL *bRes)
{
   HRESULT hr S_OK;
   hr = DS.Open("OraOLEDB.Oracle","IDTHU1","CCR_DTH_USER","P55534552");
   hr = Session.Open(DS);
   return hr;
}

HRESULT CAlterObj::LoadProcedureRules(CSession *pSession, CDBPropSet *pDbPropSet, BSTR ProductId, BSTR Revision, BSTR SubfileID)
{
   HRESULT hr S_OK;
   CCommand<CAccessor<CDbProcedureRulesGet> > sqlItems;
   hr = sqlItems.Open(*pSession, NULL, pDbPropSet);
...
}

//Tony