一个小问题,急!
我用ado连的sql server数据库,为什么执行下面代码时,提示“完成该操作所需数据还不可用”?请高手执教。
HRESULT hr;
CString ConnStr;
try
{
hr=m_pConnect.CreateInstance("ADODB.Connection");
ConnStr = "Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=study;Data Source=test";
hr = m_pConnect->Open(_bstr_t(ConnStr), "", "", adModeUnknown);
m_pRecordset.CreateInstance("ADODB.Recordset");
(buf),theApp.m_pConnect.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);
m_pRecordset = m_pConnect->Execute("select a from test.dbo.test", NULL, adCmdText);
if(m_pRecordset->adoEOF)
{
return;
}
m_pRecordset->Close();
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}