I have a large application that has begun to get to cumbersome to manage as a single project. I want to spawn it off into ActiveX dll's to be more OOP so that it can be a better base for future development and to be easier to maintain.

That program uses ADO to connect to a backend MS-SQL database. Currently when the user launches the program and logs in, a global connection is opened to the MS-SQL database and remains open for the duration of the application. This global connection is used for all recordsets created during the life of the application.

When I split the application out into dll's I would like to be able to create a similar connection which is available to the recordsets across all the dll's. This is so that I do not create multiple connections to MS-SQL and therefore run into CAL problems.

Can anyone offer any advice on how best to do this?