1

Is SqlDependency not working on GoDaddy? I'm trying to listen to a database table whenever a data change is done a particular process should be executed.

Everything is working fine in my development machine. But when I deploy it to GoDaddy it doesnt work and no error is being fired.

I'm having problems in this line

var dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);

Any thoughts?

Light
  • 465
  • 1
  • 5
  • 7
  • 1
    Did you make sure your deployment machine has no permission issues with the url you are trying to access ? – Veverke Jan 22 '17 at 08:58
  • Nice tip there. I found this when I tried access the url – Light Jan 22 '17 at 09:06
  • Cannot find the object "QueryNotificationErrorsQueue" because it does not exist or you do not have permissions. – Light Jan 22 '17 at 09:06
  • It does exists. Does GoDaddy restricts users from using query notification? – Light Jan 22 '17 at 09:18
  • 1
    I don't have anything else useful to help with, but make sure you check the links that pop up upon googling for your error message, such as [this](http://stackoverflow.com/questions/38456433/cannot-find-the-object-querynotificationerrorsqueue-because-it-does-not-exist) – Veverke Jan 22 '17 at 10:49
  • 1
    Still, pay attention to the fact that the error **may be** caused by lack of permissions, as the error message states: "... does not exst **or you do not have permissions**" – Veverke Jan 22 '17 at 10:51
  • I think its a permission isssue. Will try some approach. Thanks! – Light Jan 22 '17 at 16:29
  • It is indeed a permission issue. I tried exposing my database over the internet and it works. But using GoDaddy's DB doesnt let me to. I can't even execute ALTER DATABASE statements in GoDaddy. Thanks. – Light Jan 24 '17 at 08:41
  • I would then close this question and open another one addressing the security issue. – Veverke Jan 29 '17 at 07:34

0 Answers0