Post

ASP.NET session state store provider for MySQL available on sourceforge

I finally managed to add this project on sourceforge … here is the link

Post

ASP.NET session state store provider for MySQL (2nd Update)

A couple of days ago I received an email from Steven Davis. He proposed some brilliant enhancements to the MySQL session state store provider. Thanks to him, I am able to provide a new release of it today.

New features he incorporated into the provider are:

added cluster db support: the ability to retry within a cluster of servers, the web.config can then use connectionStringList=","
fixed timeout Minutes to TotalMinutes
changed namespace to Kimpel.MySqlSessionDll to make debugging clearer

Release v.03 now also supports MySQL Connector/Net 6.2. I also added a SQL script to create the necessary sessions table.

Post

ASP.NET session state store provider for MySql (Update)

As Joel (original URL https://cid-a4e6342ee2ff07cb.profile.live.com/) and Ciprian Tarta (original URL https://cid-9e17649272bd0cd7.profile.live.com/) mentioned, the code for the MySQL session state store provider contained a little bug in the RemoveItem method. I fixed this bug and also tried to re-format the document.

You can download the document here: https://www.kimpel.com/FileDownloader.aspx?file=MySqlSessionStateStore v.0.2.zip.

Enjoy!

Post

ASP.NET session state store provider for MySql

As I mentioned earlier here, my website ultimately is .NET ready .

Since I have quite a number of photos online that are off the record, I wanted to ‘protect’ them using forms authentication (within the former web hosting package developed in PHP I was using .htaccess and .htpassword files in order to protect complete directories).

So, from my professional experience, I know that saving data in session is feasible. However, the problem comes with a clustered environment that you usually run into in production environments. One possible solution now is to store session data in a database. Since the package I ordered at Easy CGI does not come with a MS SQL Server database (unless you add it as an additional feature to your package) you are limited to MS Access or MySql as your database management system … well, this actually isn’t that much of a choice since MS Access is not really suitable in a multi-user environment.