C++操作SQL2005更新数据库时出错!高手们请进!
提示错误:IDispatch error:#3092
网上搜了 说的是字段类型不匹配,我看我字段类型也没哪不匹配 给解决下!谢谢!
代码如下:
#include <string>
using namespace std;
#include <tchar.h>
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
void main()
{
string codenum="00001";
::CoInitialize(NULL);
_bstr_t strCnn("Provider=SQLOLEDB.1;Data Source=(local);Initial Catalog=userInfo;User Id=sa;Password=123;");
_ConnectionPtr pConnection = NULL;
try
{
pConnection.CreateInstance(__uuidof(Connection));
pConnection->Open (strCnn, "", "", adConnectUnspecified);
string str="UPDATE bookStore SET 证书路劲='ct_cer"+codenum+"' WHERE 用户编号='"+codenum+"'";
_bstr_t strUpdate=_T(str.c_str());
pConnection->Execute(strUpdate,NULL,adCmdText);
}
catch(_com_error e)
{
printf(_T("Warning: Execute方法发生异常. 错误信息: %s; 文件: %s; 行: %d\n"), e.ErrorMessage(), __FILE__, __LINE__);
}
}