Can I share a Database Connection in ASP

[JimHorton]

Hi all,
I want to be able to share a SQL7 connection for a session in an ASP application. Currently, I have an ActiveX dll which has all the db reading and writing functions, but I have to open the connection for every .asp page that makes a call to the .dll.

Is it possible to just load the .dll and open the connection once for the entire session, and then each time any .asp page is used within the session, the same instance of the .dll and the same sql7 connection is used? Ie., how would I globally maintain the .dll object variable? Thanks,
--Jim

 

[JimHorton]

Never mind...I opened my asp book...made a session variable in global.asa that contained the reference to the dll...it's working fine...
--me