Session state resets when using Access DB

Viper

Member
Joined
Aug 27, 2004
Messages
17
Location
South Africa
Programming Experience
5-10
Hi

I have an ASP.NET application that connects to an Access database. Everything works fine except for the Session object.
If I make a call to the database, the session object resets after the procedure has executed.
If I set the session state and then navigate to a page (no calls made to database), it is fine.
I tested it with a SQL Server database and it worked fine so I think the problem has something to do with MS Access.
 

m_ogden

Well-known member
Joined
Mar 3, 2006
Messages
74
Location
New Hampshire
Programming Experience
5-10
sounds like your connection to the access database is throwing an exception and possibly restarting your web app or session and therefore clearing out the session object? My app uses Access MDB files extensively with no problems.

Maybe check that the MDB file you are trying to access is not read only and that the web user (usually ASPNET for IIS5, NetworkService for IIS6) has read/edit privileges to the MDB file.
 
Top Bottom