personally I wouldn't put the db connection in the global.asa



if you need to connect on every page I would write a sub routine within an 
include file referenced from whichever page you need to connect from

also write a sub to dissconnect as well



I have used the global.asa file for hit counting in the onSessionStart 
event, haven't needed to for anything else


regards


Matt




> I am almost done with my first ASP project and have never used 
global.asa. 
G> enerally speaking, what should be put in that file? In my application, 
I 
n> eed to access SQL server DB on most of pages, so should I consider to 
put 
c> onnection set up in global.asa file? 

> Thanks,
C> indy