We have upgraded to a new version of ColdFusion Server MX7 and I am having a little problem using my VFP 7 COM Objects. The problem deals with a concept I have about COM and ADO Record Sets. I setup a Cold Fusion Page to execute a create object on my VFP COM object. Then I execute a method on the COM object that when passed a key will return a Record Set. I then release the COM object and use the returned Record Set to query the data for the record I just passed the Key for. I was believing that the COM and the ADO Record Set were mutually exclusive. That is to say I could release the COM, because I was finished with it and would then take the ADO Record Set away to another module to extract the data from the ADO Record Set. This concept worked in our past version of Cold Fusion MX6.1. But in the new version it does not. Because I am releasing the COM object, I can no longer query the ADO Record Set that was returned from the COM Method call. The error that is returned states "Object is no longer valid. in 'ADODB.Field'". So I went back to my Cold Fusion Module and took the code out that released or cleared the variable used to hold the COM object. Then the routine worked with no error returned. So my question is this - was I wrong in assuming the ADO Record set is not tied to the COM after the method returned it to me or are they truly linked as some sort of Parent and Child?

Any help on this or education for me would be appreciated.

TIA