VC如何调用存储过程
_ConnectionPtr m_connection;
_RecordsetPtr m_recordset;
_CommandPtr m_command;
HRESULT hr,hr1,hr2,hhc;
//m_connection->CommandTimeout=10;
//AfxMessageBox("chao shi");
hr=m_connection.CreateInstance("ADODB.connection");
if (SUCCEEDED(hr))
{
hr1=m_connection->Open("DSN=cc","","",-1);
AfxMessageBox("cheng gong ");
}
else
{
AfxMessageBox("shi bai");
}
if(SUCCEEDED(hr1))
{
CString sql_;
_bstr_t sql;
sql_.Format("test1");
sql=sql_;
VARIANT RecordsetAffected;
_variant_t vtEmpty (DISP_E_PARAMNOTFOUND, VT_ERROR);
_variant_t vtEmpty2(DISP_E_PARAMNOTFOUND, VT_ERROR);
hr=m_recordset.CreateInstance("ADODB.recordset");
hr2=m_command.CreateInstance("ADODB.command");
VARIANT v1,v2;
//m_recordset=m_connection->Execute(sql,&RecordsetAffected,4);
m_command->ActiveConnection=m_connection;
m_command->CommandText=_bstr_t(sql);
m_command->CommandType=adCmdStoredProc;
hhc=m_command->Execute(&vtEmpty,&vtEmpty2,adCmdStoredProc);
}
else
{
AfxMessageBox("bbbbbbbbbbbbbbbbbbbbbbb");
}
if(SUCCEEDED(hhc))
{
AfxMessageBox("BBBBBBBBBBBBBBBBBBBBBBBBB");
}
else
{
AfxMessageBox("CCCCCCCCCCCCCCCCCCCCCCC");
}
}
hhc总是返回S_FALSE
请问这是为什麽,应如何正确存储过程,请大虾帮忙可,急!!!!!!!!