Hi,
I have a SQL 7 server and I created a store procedure which insert a new record into a table.
This table has a field declared as numeric and the SP has a corresponding numeric variable.
From my VB application I have to call this SP; I tried with the ADODB.command way and CreateParameter method.
CreateParameter("myVar", adNumeric, adParamInput, 9, myValue)


When I call Execute I receive this error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Why? Where is the mistake?
The ADO version is 2.6 and my OS is Windows 2000.

Thanks
Marco