Click to See Complete Forum and Search --> : Designing/Implementing Database Component


houdesk
December 13th, 1999, 12:59 PM
I am trying to design a database component that could be simultaneously accessed and shared by multiple clients. For instance I want to create a component that has an ADO Connection object as one of its attributes that would be initialized when the first client needed to access the database, and destroyed when the last client released the object. If anyone could point me in the right direction, I would really appreciate it.

Thanks

Mikesc
December 14th, 1999, 08:59 AM
Check out Microsoft Transaction Server available for free download from the microsoft site in an NT 4 service pack, but it works on win9x as well.
I think what your talking about is called object pooling. This is not availabe in MTS for win9x but MTS will create and destroy your object as needed or according to your settings. In Win 2000 MTS has been integrated with COM+ and does support object pooling.