I have an MTSDataModule, which is successfully pooled under COM+. The problem I have is that I must connect to the database on Activate, and Disconnect from the database on DeActivate. This means that each time the pooled object is used again, the database connection has to be recreated. This doesn't work if I connect to the database in the Create (I get the error Connection does not exist when trying to execute a query).
 
Any  suggestions?
 
Thanks. Stacey.
 
Stacey Verner             Ph:   +64-9-4154790
Software Developer        Fax:  +64-9-4154791
CJN Technologies Ltd.     Email: [EMAIL PROTECTED]
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at
http://www.cjntech.co.nz/
 

Reply via email to