可以连接数据库,但不能操作,咋办?
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
_CommandPtr pCmd(__uuidof(Command));
pConn->Open("Data Source=student;UID=;PWD=","","",adModeUnknown);
MessageBox("");
pCmd->put_ActiveConnection(_variant_t((IDispatch*)pConn));
pCmd->CommandText="select * from student";
pRst=pCmd->Execute(NULL,NULL,adCmdText);//这一句,一直提示异常,无法解决,然后退出了
while(!pRst->rsEOF)
{
((CListBox*)GetDlgItem(IDC_LIST1))->AddString(
(_bstr_t)pRst->GetCollect("au_lname"));//把内容读取到ListBox控件中
pRst->MoveNext();
}
pRst->Close();
pConn->Close();
pCmd.Release();
pRst.Release();
pConn.Release();
CoUninitialize();
_CommandPtr m_pCommand;
pCmd.CreateInstance("ADODB.Command");
_variant_t vNULL;
vNULL.vt = VT_ERROR;
vNULL.scode = DISP_E_PARAMNOTFOUND;///定义为无参数
pCmd->ActiveConnection = pConn;///非常关键的一句,将建立的连接赋值给它
pCmd->CommandText = "select * from student";///命令字串
m_pRecordset = m_pCommand->Execute(&vNULL,&vNULL,adCmdText);