ado rs.open stored procedure problem

[shmiller]

I'm using ado and opening a recordset from a stored procedure in SQLServer 7.0

rs.Open "proc...", gcnn, adOpenStatic, adLockOptimistic

When the above line executes, the recordset fails to open but no error event is raised and execution continues. If I check the ado errors collection, I get the warning message passed back by SQL. It's a "null eliminated from aggregate" warning. When I execute the procedure in Query Analyzer, I get the warning message, but I also get my results.
Is there any way to set ado to ignore warnings messages and open the recordset?? If not, how do I keep my proc from returning a warning message??
Any help would be greatly appreciated.
Thanks

smiller@kodak.com

 

[tlbroadbent]

Issue a Set ansi_warnings off command at the start of the stored procedure. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.