return from stored procedure do not work

[mutley]

Hi

I am call the Stored Procedure from VB I put
Set qd = New ADODB.Command and when I put the property

qd.CommandType =adCmdStoredProc

It do not work , give me a messagem RUNTIME-ERROR '-2147217900' SINTAX ERROR OR ACCESS VIOLATION

but when I put

qd.CommandType =adCmdText
It WORK , but a parameter that I put
qd.Parameters.Append qd.CreateParameter("rc", adInteger, adParamReturnValue)

Do not return and this procedure only return values (0 or 1 or 2 or 3),but do not work

thank you in advance