Dbase connection in Global.asa?

Results 1 to 4 of 4

Thread: Dbase connection in Global.asa?

  1. #1
    SteveW Guest

    Default Dbase connection in Global.asa?

    Is it best practice to build a database connection variable in global.asa and then call it when needed on the page?<BR><BR>I have a site that has database connection in an include file. <BR><BR>Is it worth changing over?

  2. #2
    Join Date
    Dec 1969

    Default RE: Dbase connection in Global.asa?

    Well about db connections there is a common perception that create them as late as possible and destroy them as early as possible,so its very bad practise to open db connection in globala.asa!

  3. #3
    Culture Guest

    Default RE: Dbase connection in Global.asa?

    I concur with what has been said before - but if you are simply putting all the variables in the global asa (ie the connection string) and not activating it until in the page, then i can&#039;t see any problem.<BR>Major pain though :)<BR><BR>use includes :)

  4. #4
    Join Date
    Dec 1969

    Default RE: Dbase connection in Global.asa?

    I completely disagree - keeping the connection string in an Application variable is a really good idea, much better than using an include. Defining page-global variables in include files is a recipie for maintenence headaches - 6 months down the line you can&#039;t remember what variables are defined or where...<BR><BR>Dunc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts