4,011
社区成员
发帖
与我相关
我的任务
分享
_ConnectionPtr pConn("ADODB.Connection");
CString strConn = "Provider=SQLOLEDB.1;Password=" + m_StrPassword + ";Persist Security Info=True;User ID=" + m_StrUsername + ";Initial Catalog=" + m_StrDatabase + ";Data Source=" + m_StrServer;
pConn->Open(_bstr_t(strConn),"","",adConnectUnspecified);
_CommandPtr pCmd("ADODB.Command");
pCmd->ActiveConnection = pConn;
pCmd->CommandText = "/*SQL语句*/";
pCmd->Execute(NULL,NULL,adCmdText);
将pCmd-> Execute(NULL,NULL,adCmdText);
改成:
_variant_t RecordsAffected;
pCmd-> Execute(&RecordsAffected,NULL,adCmdText);
再试试..