What does the “Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source” error mean?

I've gotten the "Cannot change the ActiveConnection property of a Recordset object which has a Command object as its source" error in my classic asp page a couple of times, usually after I've just changed a stored procedure.

In the past, uninstalling and reinstalling the COM+ applications and a reset of IIS has seemed to fix this problem. I'd assumed that the old ActiveConnection property was somehow being held in memory and the workaround was flushing it out. Today, no such luck.

So my first question is, "What does this error actually mean?" The second question is, "How do I fix it?"

I've tried consulting the following links, but as a COM+ novice this is currently over 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

5
задан Thomas Langston 15 October 2012 в 19:35
поделиться