ado调用存储过程为何的不到输出参数的值???
cnscc 2002-04-28 10:37:11 CString strSrcAddr="SP0001"
_ariant_t vValue;
_CommandPtr pCmd;
HRESULT hr = pCmd.CreateInstance(__uuidof(Command));
_variant_t vValue;
try
{
//创建存储过程
pCmd->PutCommandText("GetEnterprisePsw");
pCmd->ActiveConnection = m_pConnection;
pCmd->Parameters->Append(pCmd->CreateParameter
("EnterpriseID",adChar,adParamInput,6,_bstr_t(strSrcAddr)));
pCmd->Parameters->Append(pCmd->CreateParameter
("Authenticator",adChar,adParamOutput,16,vValue));
pCmd->Execute(NULL,NULL,adCmdStoredProc);
}
catch(_Com_error &e)
{...}
输出参数vValue总是ET_EMPTY,存储过程本身没有问题,在SQLSERVER中完全执行正确
谢谢大家!!!