Paul Young
03-18-03, 13:07
| I have some code that works just fine EXCEPT when I call a certain stored procedure. When I call the "special" sp, the first time I reference the result set I get an error "Operation is not allowed when the object is closed." source "ADODB.Recordset". I can substitute sp_who3 for the "special" sp and everything works! I am stumped as to what the problem could be or what to do next. Any help would be appreciated! The sub is attached |