Stored Procedure Parameter not seen by ADODB.Command object

[mdlueck]

I have a very odd bug today... I am working on cloning a bunch of SP's to query data slicing from a different hierarchical level than current production SP's. I cloned my SP, made the needed adjustments, and clearly see the required parameter via SSMS.

Bang in VBA touching the SP! It acts like the SP has no parameter!

View of the SP tree in SSMS:

View of what VBA recognizes the SP as:

Suggestions why the umpteenth Stored Procedure call from Access / VBA is not working correctly?

And yes, I already tried my DB cleanup to see if that might shake Access / VBA back to sense, nadda.

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk/forums/showthread.php?t=219948

 

[mdlueck]

Never mind...

I had added the _Product suffix to the SP name incorrectly in VBA. It was correct in SQL Server.

I adjusted it / runs as expected.