请大家看看为什么出错
请大家看看为什么出错
通过ADO来操作数据表
void rxgasid::OnBnClickedButton1()
{
rxgasid ttt;
_ConnectionPtr db;
_CommandPtr m_pCommand;
CString sql="select * from street";
db.CreateInstance(__uuidof(Connection));
db->Open("Provider=sqloledb;server=infodb;DataBase=infodb;uid=sa;pwd=1111","","",-1);
_RecordsetPtr m_pUserSet;
m_pUserSet.CreateInstance (__uuidof(Recordset));
m_pUserSet->Open("select * from street where id=2",theApp.db.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
_variant_t var;
CString strName;
var = m_pUserSet->GetCollect("name");
strName = (LPCSTR)_bstr_t(var);
MessageBox (strName);
}
提示错误
如下
Unhandled exception at 0x77e6a4e1 in ttt.exe: Microsoft C++ exception: _com_error @ 0x0012e8e4.