SqlDependency.Start(connectionString)每次返回false [英] SqlDependency.Start(connectionString) return every time false

问题描述

我将访问数据库"的权限设置为全部"

I set All right to acces the DataBase

use DbName
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO dbuser
use DbName
GRANT SELECT ON OBJECT::schema.tableName TO dbuser
Use DbName
GRANT RECEIVE ON QueryNotificationErrorsQueue TO dbuser
ALTER DATABASE DbName SET TRUSTWORTHY ON
use DbName
alter database DbName SET ENABLE_BROKER

但是当我启动 SqlDependency 时:

bool started = SqlDependency.Start(connectionString);

//started为false，然后出现此错误

//started is false and then I get this error

System.Data.dll中发生了类型为'System.InvalidOperationException'的异常，但未在用户代码中处理附加信息:在不提供选项值的情况下使用SqlDependency时，必须在执行添加到SqlDependency实例的命令之前调用SqlDependency.Start().

C#代码:

private static bool notificationEnabled = false;
private string connString= "Data Source=(local);Initial Catalog=MyDB;UID=dbuser; PWD=pass;";
    public static void EnableNotifications()
    {
        // prevent for calling twice 
        if (notificationEnabled)return; 

        System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications(connString);
        //startResult is false always
        bool startResult = SqlDependency.Start(connString);
        notificationEnabled = true;
    }

推荐答案

尝试将队列名称添加到开始"中:

Try adding the queue name to your Start:

bool startResult = SqlDependency.Start(connString, queueName)

我还必须将服务名称和超时添加到SqlDependency构造函数中，以使事情正常进行.(它在VB中，但您知道了)

I also had to add the service name and timeout to my SqlDependency constructor to get things to work right. (its in VB, but you get the idea)

dependency = New SqlDependency(command, "Service=" + SERVICE_NAME + ";", Int32.MaxValue)

这篇关于SqlDependency.Start(connectionString)每次返回false的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！