But I’ve been a VB(3,5&6) client/server guy for years.
At my new gig we have some classic ASP that connets to a DB with connection objects. The Connection Strings are in the ASP code.
I’ve suggested moving them off into a Global.asa (there isn’t one now) for security and to make life easier when moving from test to production and vice versa.
What is the best approach? Put the Connection objects and their connection strings in Global.asa or just keep the connection strings there and let the pages continue to create the Connection object while pulling info from Global.asa?
What scope should be used for the objects/variables in the “best” approach (session, page or application)?
I do know this page gets hit by many users so performance is a factor.