Recordset的AddNew()失败,请高人指点!
::CoInitialize(NULL);
HRESULT hr;
try{
hr=m_pConnection.CreateInstance("ADODB.Connection");
if(SUCCEEDED(hr)){
CString connStr="Provider=Microsoft.Jet.OLEDB.4.0;Source=MyDatabase.mdb";
hr=m_pConnection->Open(
(_bstr_t)connStr,(_bstr_t)"",(_bstr_t)"",adModeUnknown);
}
}
catch(_com_error e)
{
//............
}
//.............
CString strSql="select * from MyTable";
BSTR bstrSql=strSql.AllocSysString();
m_pRecordset->Open(bstrSql,_variant_t((IDispatch*)m_pConnection,true),
adOpenDynamic, adLockOptimistic, adCmdText);
AfxMessageBox("程序运行时将弹出此对话框");
m_pRecordset->AddNew();//运行时错误!
//.........
::CoUninitialize(NULL);
问题在哪?该如何解决?谢谢!