Last post Aug 29, 2007 05:05 AM by tonis2
Aug 28, 2007 06:56 AM|tonis2|LINK
Aug 28, 2007 08:03 AM|naturehermit|LINK
Have you set the Session state mode to Sql Server in web.config and in IIS?
Aug 28, 2007 09:35 AM|tonis2|LINK
I don't think that I have. How do you do that?
Aug 28, 2007 09:45 AM|naturehermit|LINK
Well to do that in IIS
right click website/webapp-properties->Asp.net Tab->Press Edit Configuration->Select State Management->Select Session state mode dropdown to Sql Server, specify the connectionstring in connectionstring setting.
Aug 28, 2007 09:55 AM|naturehermit|LINK
I am terribly sorry I have been guiding you for Session in Sql server rather then caching.
Try this as a sample first ...
Aug 29, 2007 05:05 AM|tonis2|LINK
OK, I got it working now. Thank you for your help! I tried the example on this page that you suggested using my original database, but it didn't work. I created a simple test database for the example and that worked just fine. I needed to disable the cache
dependencies for the tables in my original database and then re-enable them. I think the problem was that since the table names in my database are written all in capital letters, I needed to write the table names in capital letters also when using the aspnet_regsql
tool to enable them for cache notification, like this:
aspnet_regsql .... -et -t TABLENAME