m_pConnection->Open( )未指定错误 VC ado sql

_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
void C管理系统Dlg::OnBnClickedOk()
{
// TODO:
::CoInitialize(NULL);
_variant_t RecordsAffected=3;
HRESULT hr;
try
{
hr=m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
hr=m_pConnection->Open("Data Source=PC-201204231030;Initial Catalog=HR1;Persist Security Info=True;User ID=sa;Password=a;Pooling=False;","","",adModeUnknown);
if(SUCCEEDED(hr))
hr=m_pConnection->Execute("Insert Into Table1(a,b)values('d','f')",&RecordsAffected,adCmdText);
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
}

_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;
void C管理系统Dlg::OnBnClickedOk()
{
// TODO:
::CoInitialize(NULL);
HRESULT hr;
try
{
hr=m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
hr=m_pConnection->Open("Data Source=PC-201204231030;InitialCatalog=HR1;Persist Security Info=True;UserID=sa;Password=a;Pooling=False;","","",adModeUnknown);
if(SUCCEEDED(hr))
hr=m_pConnection->Execute("Insert Into Table1(a,b)values('d','f')",NULL,adCmdText);
}
catch(_com_error &e)
{
AfxMessageBox(e.Description());//获取详细的错误信息

}
}
我不知道你的m_pConnection->Open和("Insert Into Table1(a,b)values('d','f')"语句的正确性，你自己应该知道，其他的没有什么了，