I am returning a recordset and one output parameter from my Stored Procedure. When I run it from SQL Analyzer, it works fine. But when I call the Stored Procedure from ADO, it seems like the recordset is returned, but the output parameter is not. Is this a bug or by design? Are there any work arounds? Thanks in advance.
P.S I have many many Stored Procedures that I am using from essentially the same ADO code and they all work, but this happens to be the first Stored Procedure that we have used that returns BOTH a recordset AND an Output Parameter.
P.S I have many many Stored Procedures that I am using from essentially the same ADO code and they all work, but this happens to be the first Stored Procedure that we have used that returns BOTH a recordset AND an Output Parameter.