带参数查询？？

[knmfkr]

_ConnectionPtr m_pConn;
_CommandPtr m_pCmd;
_ParameterPtr m_pParam;
_RecordsetPtr m_pRec;
m_pConn.CreateInstance(__uuidof(Connection));
m_pCmd.CreateInstance(__uuidof(Command));
m_pParam.CreateInstance(__uuidof(Parameter));
m_pRec.CreateInstance(__uuidof(Recordset));
m_pConn->ConnectionString = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=Northwind;Data Source=.;Extended Properties='pwd=sa'";
m_pConn->ConnectionTimeout = 20;
m_pConn->Open("","","",adConnectUnspecified);
m_pCmd->ActiveConnection = m_pConn;
m_pCmd->CommandText = "select OrderID,CustomerID from Orders where OrderID>=@i_ID";
m_pCmd->CommandType = adCmdText;

m_pParam.CreateInstance(__uuidof(Parameter));
m_pParam->Name="@i_ID"; //所用存储过程参数名称
m_pParam->Type=adInteger; //参数类型
//m_pParam->Size=32; //参数大小
m_pParam->Direction=adParamInput;//表明是输入参数
m_pParam->Value=_variant_t((long)10248);
m_pCmd->Parameters->Append(m_pParam);
m_pRec = m_pCmd->Execute(NULL,NULL,adCmdText);
while(!m_pRec->adoEOF)
{

}


上面的代码运行会出错，请教各位大侠！！

[knmfkr]

m_pRec = m_pCmd->Execute(NULL,NULL,adCmdText);
这行代码出错，帮忙看看！！
谢谢了！！顿首中。。。。。。。

[knmfkr]

没有人回答我
自己搞定了
m_pCmd->CommandText = "select OrderID,CustomerID from Orders where OrderID>=@i_ID";
搞成
m_pCmd->CommandText = "select OrderID,CustomerID from Orders where OrderID>=?";

其他不用改了，就可以运行

[qap22]

友情up