MTS and COM !
-
Hi, I am developing a COM component in VC++. I am deploying the component in MTS. I am using SQl Server 7.0 as my database.Also using ADO recordset and stored procedures.After deploying the component in MTS and run my client, I am getting the following error.Anybody can pls help me in this regard. Error: 07-29-2000--19:46:56-Component CContactDB::GetAllContacts:-2146824584 :Unknown error 0x800A0E78! ADODB.Recordset! The operation requested by the application is not allowed if the object is closed.ÍýýýýÝ GetAllContacts is my own function which will retrieve some info based on a query. Kindly get back to me ASAP. Thanks in advance. Regds guru
-
Hi, I am developing a COM component in VC++. I am deploying the component in MTS. I am using SQl Server 7.0 as my database.Also using ADO recordset and stored procedures.After deploying the component in MTS and run my client, I am getting the following error.Anybody can pls help me in this regard. Error: 07-29-2000--19:46:56-Component CContactDB::GetAllContacts:-2146824584 :Unknown error 0x800A0E78! ADODB.Recordset! The operation requested by the application is not allowed if the object is closed.ÍýýýýÝ GetAllContacts is my own function which will retrieve some info based on a query. Kindly get back to me ASAP. Thanks in advance. Regds guru
Hi Your problem is quite a common one in MTS. the problem may be because you are using a transactional component and the recordset is getting closed before you can access it. You must remember that MTS normally deactivates a component after every method call(thus the expression stateless objects)in which you Complete a transaction. What you must do is to ensure that your state is maintained for as long as you want. Thus the best way would be to use the DisableCommit of the IObjectContext interface at an appropriate place like for example in your IObjectControl::Activate method. This ensures that no transactions are completed until you specify a SetComplete on your IObjectContext method. I would advise making a method which does this SetComplete. Putting cleanup code in FinalRelease of your component is tricky because you cannot know how many times MTS will activate and deactivate your object. rather it is better to either make a cleanup function of your own or use the Deactivate method of IObjectControl. I hope this helps to solve your problem. If not then email me and I can give you some sample code. I am even mailing you a copy of this suggestion.