[AccessD] Retrieving output param from stored procedure (ADO CMD Param)

[William Benson]

Does it depend on which ado version referenced in your reference to ADO?
Did you test those constants can be found in the object browser (F2 in VBA)

On Mon, Jun 13, 2022 at 4:23 PM Ryan W <wrwehler at gmail.com> wrote:

> Can anyone point out what I'm doing wrong?
>
> Trying to retrieve a VARCHAR type output parameter from a stored proc:
>
> The only DataTypeEnum that has worked for me is adBSTR
>
>
> https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/datatypeenum?view=sql-server-ver16
>
>
> If I use adVarChar, adVarWChar, adLongVarChar, adLongVarWChar I get an
> "Item not found in collection" message. (error 3265).
>
> If I use adBSTR it works but I haven't tested on what it'll do if I return
> a simple INT data type but it DOES work with VARCHAR(MAX).
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
*Regards,*


*Bill Benson*
*VBACreations*

PS:  You've gotten this e-mail *because you matter to me!*