ConnStr in Session Variable

Results 1 to 3 of 3

Thread: ConnStr in Session Variable

  1. #1
    Join Date
    Dec 1969

    Default ConnStr in Session Variable

    Can anyone tell me if it is reasonable practice to store a whole connection string in a session variable instead of just the username and password? I'm thinking of creating the ConnStr when a successful login occurs and storing it in a session variable so I can use it anywhere within the app and handle security issues as well. Any takers?

  2. #2
    Join Date
    Dec 1969

    Default If only one DB user...

    ...use an application variable. Otherwise, the session variable is fine for individual db user accounts.

  3. #3
    Join Date
    Dec 1969

    Default RE: ConnStr in Session Variable

    I don&#039;t see why not...<BR><BR>Many people use Application variables to hold connection strings. True, it means that it&#039;ll be replicated for each authenticated user on your application, but if it&#039;s part of your security then it&#039;s valid.<BR><BR>Craig.

Posting Permissions

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