VC如何调用存储过程

foolish2002 2003-09-25 03:51:30

_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

请问这是为什麽，应如何正确存储过程,请大虾帮忙可，急！！！！！！！！

...全文