Output parameters with SQL Stored Procs

[Sutradhaar]

I cant get any output parameters to work. I use CreateParameter on the _CommandPtr and append them all to the parameters collection ... values get passed in but output parameters come back as VT_EMPTY. I know the stored proc is fine coz it works when tested in the iSQLw environment (SQL Server).

[shetu]

hi,
when u want tu use output parameter u have to declare it as out , andin sored procedure u have to declare the prameter in which u are returning value as out. if it is not clear u can post a message on user name 'shetu' , send the stored proc and i will send u the code for getting the value . if possible also give the code written in vb to fetch the out para value.

shweta