OK. I stopped fighting RS and left the command as text and used the syntax
EXEC storedprocedure @parm1, @parm2
for the stored procedure.
Now I need assistance passing the server and database parameter in the URL instead of requiring the user to complete.