在vc里面调用存储过程时提示为过程指定了过多的参数,是什么原因?
存储过程:
ALTER PROCEDURE [dbo].[PROC_InsertOriginalFilePath]
 @StandID int,
 @DGDeviceID int,
 @PointID int,
 @FilePath varchar(200),
 @FileStoreTime datetime

AS
BEGIN
insert into OriginalDataPath values (@StandID,@DGDeviceID,@PointID,@FilePath, @FileStoreTime)
ENDvc程序:
m_pCommand->CommandText = "PROC_InsertOriginalFilePath";//存储过程名
m_pCommand->Parameters->Refresh(); //从数据库查询参数信息

//将数据插入数据库中
_ParameterPtr m_pClientID;
m_pClientID.CreateInstance("ADODB.Parameter");
m_pClientID = m_pCommand->CreateParameter("StandID",adInteger,adParamInput,sizeof(long),(_variant_t)((long)a_nClientID));
m_pCommand->Parameters->Append(m_pClientID);//加入到Command对象的参数集属性中_ParameterPtr m_pDGDeviceID;
m_pDGDeviceID.CreateInstance("ADODB.Parameter");
m_pDGDeviceID = m_pCommand->CreateParameter("DGDeviceID",adInteger,adParamInput,sizeof(long),(_variant_t)((long)a_nClientID));
m_pCommand->Parameters->Append(m_pDGDeviceID);//加入到Command对象的参数集属性中_ParameterPtr m_pPointID;
m_pPointID.CreateInstance("ADODB.Parameter");
m_pPointID = m_pCommand->CreateParameter("PointID",adInteger,adParamInput,sizeof(long),(_variant_t)((long)a_nClientID));
m_pCommand->Parameters->Append(m_pPointID);//加入到Command对象的参数集属性中

_ParameterPtr m_pFilePath;
m_pFilePath.CreateInstance("ADODB.Parameter");
m_pFilePath = m_pCommand->CreateParameter("FilePath",adVarChar,adParamInput,200,(_variant_t)((LPCSTR)a_sFileInfo));
m_pCommand->Parameters->Append(m_pFilePath);//加入到Command对象的参数集属性中

_ParameterPtr m_pFileStoreTime;
m_pFileStoreTime.CreateInstance("ADODB.Parameter");
m_pFileStoreTime = m_pCommand->CreateParameter("FileStoreTime",adVarChar,adParamInput,32,(_variant_t)((LPCSTR)sDataTime));
m_pCommand->Parameters->Append(m_pFileStoreTime);//加入到Command对象的参数集属性中m_pCommand->Execute(NULL,NULL,adCmdStoredProc);