What does it mean "Cannot change the ActiveConnection property of a Recordset that has a Command as its source"?

Question

I got the message “I cannot change the ActiveConnection property of a Recordset object that has a Command object as the original error on my classic asp page a couple of times, usually after I just changed the stored procedure.

In the past, uninstalling and reinstalling COM + and reset IIS applications seems to have fixed this problem. I assumed that the previous ActiveConnection property was somehow stored in memory, and the workaround was resolved. Today there is no such luck.

So my first question is: "What does this error really mean?" The second question: "How to fix it?"

I tried to refer to the following links, but as a COM + newbie it is now above my head.

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20626178.html

http://msdn.microsoft.com/en-us/library/ee275490(BTS.10).aspx

Answer 1

This error is most often associated with a stored procedure that returns multiple result sets or returns the number of rows (try adding set nocount onto the beginning of the procedure.)

Have you made the latest changes to the database? If so, these changes will be a good place to start your search.

P.S. , COM +, 2010 . , , :)