how to share a database connection?

David78
06-24-2002, 12:37 PM
What is the proper way to minimize the number of database connections in a 3-tier app?

I have a middle tier ("business rules" tier in Microsoft parlance) that does all the database reading and writing. The tier is compiled into an ActiveX object that runs on the web server.

Must the ActiveX object be compiled as a single-threaded EXE? Or can a DLL object share database connections?

Thinker
06-24-2002, 01:12 PM
Each time an ASP page instantiates an object from the DLL, it will
have its own connection. If the middle tier was specifically written
for and hosted under MTS, it would pool and share connections
(as long as they were made under the same security context).
A single threaded exe would be more trouble to make work than
you would think. I think if resources are going to be a problem,
then MTS (or COM+ for 2000) is the way to go.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum