Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
The database 'IM' is not enabled for SQL cache notification.My confusion is that I believe cache notifications were discontinued after 2005 and replaced with a new service in 2008 R2. Is this correct? If so, what do I need to do to allow for caching with dependency out of the SQLDataSource?
To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCach
eDependenc yAdmin.Ena bleNotific ations method, or the command line tool aspnet_regsql. To use the tool, please run 'aspnet_regsql.exe -?' for more information.
<asp:SqlDataSource ID="custItemsDS" runat="server" ConnectionString="<%$ ConnectionStrings:IMConnectionString %>" SelectCommand="...select command..." UpdateCommand="...update command..." EnableCaching="True" SqlCacheDependency="IM:ct_CustItem"> ...parameters... </asp:SqlDataSource>
<system.web> <caching> <sqlCacheDependency enabled="true"> <databases> <add connectionStringName="IMConnectionString" name="IM" pollTime="1000"/> </databases> </sqlCacheDependency> </caching>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.