-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: K_B_Rao
Message 4 in Discussion
we can store the session state in the SQL server. Practically This is very
simple to use. For Your application if reliability is more important than
performance, then SQLServer is a better option compared to InProc and State
Server
In this case we can maintain the Application in one server and Session in
another server.
You can Find the default stored procedures provided by Dot net it self in the
following
Directory. There are two Scripts one for Installing the database and another
Uninstalling the
Database
c:\windows\Microsoft.Net\Framework\version\InstallSQLstate.sql
Just Execute the Script in Query analyzer and a new database will be created
with the name "ASPState". If you open and see u can't find any tables. Open the
database "Tempdb", which contains two tables namely
1. ASPStateTempApplications
2. ASPStateTempSessions
And also it contains some stored procedure for inserting and retrieving the
data. Now, all we need to do, as ASP.NET takes care of everything else for us,
is modify the web.config so that the ASP.Net application knows it should use
SQLServer for session state management.
Consider the following example configuration in web.config file sessionState
tag. Change the sqlConnectionString According to your settings.
mode="SQLServer"
sqlConnectionString="data source=localhost;user
id=sa;password=HemaKumar"
cookieless="true"
timeout="20" />
Now How Test the application ? Just Create one sample page called
"Sample.aspx". In page Load Assign the following statements.
Session("User")="HemaKumar"
session("Company")="Exira Software"
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
