调用SQL SERVER 7 SP_who2时出错，请看代码

Question

CString                      strcomname;
CString                      strstatus;
_variant_t                   vNull;
_variant_t                   hr;
vNull.vt            =        VT_ERROR;
vNull.scode         =        DISP_E_PARAMNOTFOUND;
_bstr_t bstrProc =( L"sp_who2 " ); 
m_com.CreateInstance( __uuidof( Command ) ); // 创建命令对象
m_com->ActiveConnection = m_con;             // 指明当前连接对象
m_com->CommandText      = _bstr_t( bstrProc ); // 命令文本
m_com->CommandType      = adCmdStoredProc;     // 命令类型
m_set=m_com->Execute( &vNull,&vNull,adCmdUnknown ); 
int i=0;
while(!m_set->adoEOF)
{
hr=m_set->GetCollect("hostname");
if (hr.vt!=VT_NULL)
{
strcomname=(char*)(_bstr_t)hr;
strcomname.TrimRight();
m_display.InsertItem(i,strcomname);
}
hr=m_set->GetCollect("status");
if (hr.vt!=VT_NULL)
{
strstatus=(char*)(_bstr_t)hr;
strstatus.TrimRight();
m_display.SetItemText(i,1,strstatus);
}
hr=m_set->GetCollect("dbname");
if (hr.vt!=VT_NULL)
m_display.SetItemText(i,2,(char*)(_bstr_t)hr);
hr=m_set->GetCollect("LastBatch");
if (hr.vt!=VT_NULL)
m_display.SetItemText(i,3,(char*)(_bstr_t)hr);
m_set->MoveNext();
i++;
}
出错的地方在m_com->ActiveConnection = m_con，但不知道为什么

Answer 1

m_con连接:
m_con->Open("driver={SQL Server};Server="c2",DATABASE=master;UID=sa";,"","",adModeUnknown);

Answer 2

是你的数据库连接，关键出错的地方你把代码贴出来啊
_ConnectionPtr m_con;
HRESULT hr = m_con->Open("Provider=SQLOLEDB; Server=127.0.0.1; DATABASE=master; UID=sa; PWD=xxxx; ");
if ( FAILED(hr) )
{
 // print error message and return;
}