[RESOLVED] Problem with ADODB Command & Stored procedure

[vnatar]

Is this SQL Server ?

Should your SP Input Variable be of type - Int ?

Also can we see your Connection Code, where MyConn is being opened ?

Hi, Thanks for your time.

Yes, it is SQL Server, SP can't be changed.
MyConn is all good, because I just tried calling another SP which does not take any parameters, the same code worked fine. I could call & execute that SP.

^^ I mean to say, if i repalce the SP name & cut off the parameters portion in the "same" VB code posted above, i could execute an SP.

Problem here is with the parameters & the way i am handling it i guess. Do you see any issue in the VB code i posted here ?

Thanks again for your time.