I could do with a bit of advice;

I have a dll that contains a number of objects that can be used to query a database:

Access
Server
Contact
ContactTeam
SQL
etc.

All the objects are accessible via the Access object (which is used for validating users etc)

At the moment every ASP page recreates the Access object from scratch. I now want to persist the object either using the Application or Session objects.

It works fine creating the Access object in the Global.asa Session_Onstart sub. However if I try to create the Access object (in the Global.asa file) as an object with Application scope:

<OBJECT RUNAT="Server" SCOPE="Application" ID="MyApp" PROGID="Web.Application"></OBJECT>

my SQL object (which takes care of database connectivity etc.) will not work.


Any ideas??

Cheers
Tom