idispatch error 3092 : ADO

[youssef]

Hi,

I have an error when I executing my stored procedure.
If anyone can help me for that it is great ?


My sample code is :

I would like that the stored procedure return a int value. But I dont know how can I do this ?

_variant_t vtroyal ;
int intRoyalty =0;

//Assign Integer value
vtroyal.vt = VT_I4;
vtroyal.iVal = intRoyalty;
pParam4 = pCmd2->CreateParameter ( _bstr_t ("StartFileNumV2&quot, adInteger,
adParamReturnValue, sizeof(int), vtroyal);

pCmd2->Parameters->Append ( pParam4);

When I execute this a error message appear :

idispatch error 3092 : ADO

Best regards