Cannot read return value in stored proc.

[whatisahandle]

Hi,

I have some ASP code which works fine on an SQL7 database but not on SQL2000. It looks like this:

' --------------------------------
Set cmdLoad = Server.CreateObject("ADODB.Command&quot
cmdLoad.CommandText = "{? = call usr_GetCountProduitCatalogue(?,?)}"

cmdLoad.Parameters.Refresh
cmdLoad.Parameters("@NoCatalogue&quot = pintID
cmdLoad.Parameters("@NoCatDate&quot = rstLoad("NoCatDate&quot
cmdLoad.execute

lngCountProduit = cmdLoad.Parameters.Item("RETURN_VALUE&quot.value
' --------------------------------

I get this error:

ADODB.Parameters error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

The problem is the "RETURN_VALUE" parameter is not recognized.
But with:
cmdLoad.Parameters.Item(0).value
it works fine.

Anyone ever see this ?

Thank,

Chris