请教Command对象的使用

Question

忘了，我用的VC＋＋，Win32编程

Answer 1

ADODB::_ConnectionPtr conn;
conn.CreateInstance(__uuidof(ADODB::Connection));
conn->Open("PROVIDER=MSDASQL;driver={SQL Server};server=aaaa;uid=;pwd=;
    database=MySql","","",ADODB::adConnectUnspecified);ADODB::_CommandPtr cmd;
cmd.CreateInstance(__uuidof(ADODB::Command));
cmd->ActiveConnection = conn;ADODB::_RecordsetPtr rt ;
rt.CreateInstance(__uuidof(ADODB::Recordset));cmd->CommandText = "select * from zejk";
rt->PutCursorType(ADODB::adOpenStatic);
rt->PutLockType(ADODB::adLockOptimistic);
rt = cmd->Execute(NULL,NULL,ADODB::adCmdText);_bstr_t sno = (_bstr_t)rt->GetCollect("sname");
rt->PutCollect("sname","jjjj");   //!!!!程序在这一行就出错，执行通不过
rt->Update();请知道的大侠帮帮忙