Re: SqlNotificationInfo

Tech-Archive recommends: Fix windows errors by optimizing your registry

I've spoken to a number of customers/developers that have been able to get
SqlNotifications to work. At one point in time I included a Notification
Services demo in my sessions. However, I found that I ended up having to
provide so many warnings about its use and where it makes sense (and where
it does not) that I dropped it from my sessions. Unless you're well aware of
the implications and what's being done behind the scenes to support this
technology, it's tough to get working correctly or to design it into your
application.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Earl" <brikshoe@xxxxxxxxxxxxxxxxx> wrote in message
news:OClQLurbHHA.4632@xxxxxxxxxxxxxxxxxxxxxxx
You have any good references to point to beyond what's on MSDN? I've been
trying to fire notifications based upon events occuring in the database
and so far, the only result I've had is to lock up the database. I've
posted a couple of questions in the forums without any response, so I
figured that SqlNotifications was just vaporware. Except for this post,
I've not heard of anyone (outside of Microsoft) who actually got the
scheme working. The hazard I run into is that most developers seem to be
working for large companies where they have unlimited amounts of time to
get jerked around by features and functions that do not work "as
advertised", so ultimately they do get it resolved. Unfortunately, my
clients do not fund time for me to explore every nook and crany of some
obscure object or feature that doesn't work the way Microsoft describes
it. Even something as trivial as a bug in a Microsoft control can disrupt
my day, so you can imagine where SqlNotifications falls in that continuum.

"Eric Moreau" <eric.moreau_N_O_S_P_A_M@xxxxxxxxxxxx> wrote in message
news:eaNoVngbHHA.2188@xxxxxxxxxxxxxxxxxxxxxxx
I have an application that runs on a server which is updating stock prices
every 15 minutes from external data sources.

I have an other application that runs on users' PC. This application is
using a SQLDependency object to automatically refresh one of the screen
when changes occurs in the database. It was a bit tough to setup but it
is now working great.

--


HTH

Éric Moreau, MCSD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc. (http://www.emoreau.com/)

"Earl" <brikshoe@xxxxxxxxxxxxxxxxx> wrote in message
news:OOqx%23efbHHA.4140@xxxxxxxxxxxxxxxxxxxxxxx
Someone who actually got SqlNotifications to work? I thought that
capability was just an urban legend...

"Lubomir" <Lubomir@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96C69538-8851-4B2D-BE35-C972828DBF35@xxxxxxxxxxxxxxxx
Hi,

To capture changes in the database I am using SQLDependency. When the
change
is notified I update my UI.

In the handler for OnChangeEvent I checked what type of info is passed
to
the method argument. I find out it is "Error"

In MSDN I read it is an Internal Server Error.

However, when I ignore this error, my app works just fine (at least it
seems
to). What does mean that error?

Thanks,

Lubomir








.

Relevant Pages

  • Re: SqlNotificationInfo
    ... Notification Services demo in my sessions. ... Microsoft MVP ... database and so far, the only result I've had is to lock up the ... so I figured that SqlNotifications was just vaporware. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: fax with vista and sbs 2k3
    ... Is the fax delivery notification not reached only on Vista machine? ... Send several Fax's to the SBS server. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Event ID: 518 SAM inserted nsrestor to receive all passwords i
    ... An notification package has been loaded by the Security Account Manager. ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: multiple email notices are recieved on incoming faxes
    ... there are two kind of notification email. ... Files\Microsoft Integration\Windows Small Business Server 2003\Logs''. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)