Stored Procedures and the Name of the Return Value

[John Canny]

Hi Rob
My question is on the return value from a stored procedure that is executed
through ADO

Executing a stored procedure through ADO, against a SQL 7.0 server, the name
of the return value is ADODB.Command.parameters("RETURN_VALUE").

The same code executed against a SQL 2000 server, the name of the return
value is now ADODB.Command.parameters("@RETURN_VALUE").

Is there a way to have SQL Server 2000 use the name RETURN_VALUE instead?

Thanks
John C.

[Rob Vieira]

I hadn't run across this particular problem, and I can't seem to replicate
it.

As long as I define the return value parameter as being of direction
adParamReturnValue and create it first in the collection, I have no problem
with it at all.

Can you post some sample code on this one?


--
Rob Vieira
Visit www.ProfessionalSQL.com Today. It's new and improved!


"John Canny" <johncanny@hotmail.com> wrote in message
news:3a6dd922$1@news.devx.com...
>
> Hi Rob
> My question is on the return value from a stored procedure that is
executed
> through ADO
>
> Executing a stored procedure through ADO, against a SQL 7.0 server, the
name
> of the return value is ADODB.Command.parameters("RETURN_VALUE").
>
> The same code executed against a SQL 2000 server, the name of the return
> value is now ADODB.Command.parameters("@RETURN_VALUE").
>
> Is there a way to have SQL Server 2000 use the name RETURN_VALUE instead?
>
> Thanks
> John C.
>