Session variables and db connecting

Results 1 to 2 of 2

Thread: Session variables and db connecting

  1. #1
    Rob Teasdale Guest

    Default Session variables and db connecting

    Is it possible to connect to a db in the session on start method. I am quite new to web application development using ASP. I have to access a few tables on a SQL server during a session and thought it would save overhead to connect once at start of session, and then close at end. I am thinking in the wrong direction. Your sage words of wisdom can only enlighten my path,<BR>Cheers<BR>Rob

  2. #2
    Join Date
    Dec 1969

    Default RE: Session variables and db connecting

    Rob<BR>I never put a connection to a db in a session object.<BR>when it can be avoided, never put the db conn string into a session.<BR>please refer to this article on the subject and see TIP #6 in it:<BR><BR>I always open and close db conn strings and Recordsets explicitly on each file.<BR>My opinion.<BR>Andy

Posting Permissions

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