error C2039 getInterfacePtr is not a member of _Connection (using ADO)
Hi
I'm not sure this is the right for forum for this question, but I'm
getting a
"error C2039 getInterfacePtr is not a member of _Connection (using
ADO)" when trying to set up a simple query of an Access 2002 table
with MFC..
1) Anyone have any ideas why my connection doesn't seem to have
GetInterfacePtr?
2) is ADO the best data acess method to use with MFC?
thanks,
Tony C.
code:
========================================================
HRESULT hr;
_ConnectionPtr m_pConn;
m_pConn.CreateInstance (__uuidof(Connection));
try
{
m_pConn->Open (_bstr_t (
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
C:\\DATABASES2\AstroCalc.MDB" ),
_bstr_t ( "" ),
_bstr_t ( "" ),
adModeUnknown );
}
catch ( _com_error &e)
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDesc(e.Description());
CString strErr((char *)bstrDesc);
TRACE(strErr + '\n');
}
_CommandPtr pCmd;
pCmd.CreateInstance ( __uuidof (Command));
try
{
pCmd->ActiveConnection = m_pConn;
}
catch( _com_error &e)
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDesc(e.Description());
CString strErr((char *)bstrDesc);
TRACE(strErr + '\n');
}
_RecordsetPtr MyRecSet;
hr = MyRecSet.CreateInstance(__uuidof(Recordset));
if (FAILED(hr))
{
throw _com_error(hr);
}
OFFENDING LINE: ======>>> MyRecSet->Open("SELECT * FROM stars,
,m_pConn->getInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
==============================================================