entaroadun
Programmer
I am new to COM+ and transactional programming in general, so please bear with me...
I am writing in VB 6 for a W2K SP2 machine.
I have two components: a business logic and a database-write. The business logic component requires a transaction. It is accessed by the client application. It instantiates the database component to do the actual updates. Can I set the database-write component to not support transactions?
I want to do this because I want my database component to retain state within the business component transaction. I want to call Database.Initialize(), Database.AddParameters(), Database.Execute() from within a Business.UpdateData() function. If the Database component supports transactions, then the state of the instance disappears between method calls. Of course, I want the Database component to lose state, but only after the entire Business transaction is done.
Is this possible?
As an aside, how do I make it so the Database component can only be instantiated from within the Business component? I have to set the class as Multiuse, which makes it public. I don't want the client app to be able to instantiate Database components. I am new to COM+ roles and security so I need guidance here as well.
Thank you all very much for any help you can provide.
I am writing in VB 6 for a W2K SP2 machine.
I have two components: a business logic and a database-write. The business logic component requires a transaction. It is accessed by the client application. It instantiates the database component to do the actual updates. Can I set the database-write component to not support transactions?
I want to do this because I want my database component to retain state within the business component transaction. I want to call Database.Initialize(), Database.AddParameters(), Database.Execute() from within a Business.UpdateData() function. If the Database component supports transactions, then the state of the instance disappears between method calls. Of course, I want the Database component to lose state, but only after the entire Business transaction is done.
Is this possible?
As an aside, how do I make it so the Database component can only be instantiated from within the Business component? I have to set the class as Multiuse, which makes it public. I don't want the client app to be able to instantiate Database components. I am new to COM+ roles and security so I need guidance here as well.
Thank you all very much for any help you can provide.