Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Changing the SQL Session state connection programmatically

Reply
Thread Tools

Changing the SQL Session state connection programmatically

 
 
Thina
Guest
Posts: n/a
 
      10-25-2006
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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 2.0 Session State and ASP.NET 1.1 Session State jnickfl1 ASP .Net 0 09-18-2006 03:23 PM
Unable to make the session state request to the session state server Maciek ASP .Net 0 09-15-2005 08:49 PM
Unable to serialize the session state. Please note that non-serializable objects or MarshalByRef objects are not permitted when session state mode is 'StateServer' or 'SQLServer'. Mike Larkin ASP .Net 1 05-23-2005 12:33 PM
Unable to make the session state request to the session state server Not Liking Dot Net Today ASP .Net 0 04-21-2004 11:54 AM
unable to make the session state request to the session state server shamanthakamani ASP .Net 1 11-20-2003 04:51 AM



Advertisments