Changing the SQL Session state connection programmatically

Discussion in 'ASP .Net' started by Thina, Oct 25, 2006.

  1. Thina

    Thina Guest

    My application uses SQL session state. In Test Server the session state
    would be pointing to Test DB Server, similarly the Prod Server to Prod
    DB Server. Is there a way to programatically change session to point
    Test DB to Prod DB Server? That is, I would use the same web.config
    file. So, no matter where the code resides the web.config remain same.
    For normal connections this can be achieved by recognizing the server
    name, but that is done during runtime, it is not the matter with
    session state as it needs to be initiated at compile time.

    Any help would be appreciated!

    Thanks!

    Thinagaran
     
    Thina, Oct 25, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. shamanthakamani
    Replies:
    1
    Views:
    3,497
    Natty Gur
    Nov 20, 2003
  2. Not Liking Dot Net Today
    Replies:
    0
    Views:
    614
    Not Liking Dot Net Today
    Apr 21, 2004
  3. Maciek
    Replies:
    0
    Views:
    8,255
    Maciek
    Sep 15, 2005
  4. jnickfl1
    Replies:
    0
    Views:
    595
    jnickfl1
    Sep 18, 2006
  5. Harry Haller
    Replies:
    0
    Views:
    1,661
    Harry Haller
    Nov 7, 2006
Loading...

Share This Page