ADO遇到的问题
void CCommandDlg::OnOkButton()
{
UpdateData(TRUE);
// 初始化OLE/COM库环境
::CoInitialize(NULL);
try
{
// 创建Connection对象
m_pConnection.CreateInstance( "ADODB.Connection ");
// 设置连接字符串，必须是BSTR型或者_bstr_t类型
_bstr_t strConnect = "Provider=SQLOLEDB;Server=127.0.0.1;Datebase=UserMan;uid=sa;pwd=sa; ";
m_pConnection-> Open(strConnect, " ", " ",adModeUnknown);
// 判断连接状态是否为连接
if(m_pConnection-> State == adStateOpen)
{
m_pCommand.CreateInstance( "ADODB.Command ");
m_pCommand-> ActiveConnection = m_pConnection;
_bstr_t vSQL;
vSQL = "INSERT INTO Users (UserName,UserPwd) VALUES ( 'tester ', '999999 ') ";
// "UPDATE Users SET UserPwd= ' " + m_pwd + " ' WHERE UserName= 'lee ' ";
m_pCommand-> CommandText = vSQL;
// 执行命令
m_pCommand-> Execute(NULL, NULL, 0);
MessageBox( "密码更新成功 ");
}
else
MessageBox( "断开连接 ");
// 关闭连接
m_pConnection-> Close();
}
// 捕捉异常
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox(e.ErrorMessage());
}

OnOK();
}

为什么会在此处异常m_pCommand-> Execute(NULL, NULL, 0);
从树上抄来的例子


[解决办法]
comm-> Execute(NULL,NULL,adCmdText);