Connecting with global.asa

Results 1 to 2 of 2

Thread: Connecting with global.asa

  1. #1
    Join Date
    Dec 1969

    Default Connecting with global.asa

    I am looking for some help connecting to a SQL Server database from the global.asa file. I found an article here ( that uses a session variable to store the connection. This article has a note on it that using session variables for large objects is not a good idea. I agree. Is there another option? Is there a way to create a connection in the global.asa and have it available to the asp pages?<BR><BR>Thanks,<BR>Lori<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Connecting with global.asa

    I put my connectionstring in an Application() variable, then open the connection on each page. it really is a lot more efficient than trying to store a connection in session (which will nail your server&#039;s performance to the ground)<BR><BR>j<BR>

Posting Permissions

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