如何启用SqlCacheDependency [英] How to Enable SqlCacheDependency
问题描述
我尝试为我的表tblemployee启用sqlCacheDependency..
像这样的格式:C:\ Windows \ Microsoft.NET \ FrameWork \ v2.0.50727> aspnet_regsql.exe -E -d Milton -et -t tblemployee
--------------------------------------
那时我在下面出现错误.
为表启用SQL缓存依赖性.
......发生了错误.例外的详细信息:
建立连接器时发生与网络相关或特定于实例的错误
对SQL Server的引用.服务器未找到或无法访问.确认
实例名称正确，并且该SQL Server配置为允许远程
连接. (提供者:命名为管道提供者，错误:40-无法打开连接器
对SQL Server的引用)
无法连接到SQL数据库以进行缓存依赖项注册.
请帮助我.
I try to enable sqlCacheDependency for my table tblemployee..
Like this format: C:\Windows\Microsoft.NET\FrameWork\v2.0.50727>aspnet_regsql.exe -E -d Milton -et -t tblemployee
--------------------------------------
On that time I got error below.
Enabling the table for SQL cache dependency.
...............An error has happened. Details of the exception:
A network-related or instance-specific error occurred while establishing a conne
ction to SQL Server. The server was not found or was not accessible. Verify that
the instance name is correct and that SQL Server is configured to allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a conne
ction to SQL Server)
Unable to connect to the SQL database for cache dependency registration.
Please help me.
推荐答案
您在MSDN上得到了任何答案吗?
请参见此处.
Did you get any answers on MSDN?
See here.
查看选项
aspnet_regsql/?
启用数据库学校是数据库名称
aspnet_regsql -S本地主机-E -d学校-ed
启用表用户是tbl名称
aspnet_regsql -S本地主机-E -t用户-d学校-et
to see option
aspnet_regsql /?
to Enable database school is db name
aspnet_regsql -S localhost -E -d School -ed
to Enable table Users Is tbl name
aspnet_regsql -S localhost -E -t Users -d School -et
这篇关于如何启用SqlCacheDependency的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
