Last post Mar 16, 2011 06:19 PM by AndyMoireASP
Feb 26, 2011 02:52 PM|AndyMoireASP|LINK
I am creating a web application that will be running on an infrastructure which will utilise a number of web servers, web gardens and a load balancer.
As the application is using Sessions, and that our application is using Oracle as the database, we would like to use the database to save the Session data. However, I am struggling to find any good examples on how to do this with Oracle.
I note that Oracle provides the following class: Oracle.Web.SessionState.OracleSessionStateStore, but I am unsure what I need to do in the Code Behind and what if any tables do I need to create in the database.
Can anyone help me, please?
Feb 27, 2011 02:42 AM|roopeshreddy|LINK
Check the following links
Hope it helps u...
Mar 16, 2011 06:19 PM|AndyMoireASP|LINK
There is a much better solution that I have learnt from Oracle.
If you install Oracle Client 11g, there is a module in the ODP.Net called ASP.Net. This provides a dll called Oracle.Web.dll, which can be installed in your solution/project. The client will work with Oracle 10g R2.
After installing the client navigate to a folder for ASP.Net, in this folder, there are some sql scripts. loaded the main script that loads the Oracle Session Provider.
Once this is done, just use the custom provider configuration in the web.config and that's it!