Re: SqlNotificationInfo

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: Dataset with master and multiple nested tables in DotNet 2.0 WinFo
    ... Are you having trouble to put modified data back to DataSet or update data ... back to the database? ... I have some good samples in MSDN that ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Development - Access or MSDE?
    ... I got - from a reference in MSDN I believe. ... embedded database is hefty. ... I don't think I could convince users of my ... shareware that a 50 meg install file is OK :-) ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie to VSTO
    ... Walkthrough: Binding Cells to Multiple Columns in a Table ... MSDN library. ... I want to populate excel from a database table, ...
    (microsoft.public.vsnet.vstools.office)
  • SSO Confiugration and PayStub Sample
    ... I'm trying to get the PayStub sample posted to MSDN ... errors in the event log or in the database. ... "The DataCache database 'Paystubdata' cannot be reached on server ... 'SERVER' with the credentials obtained from SSO. ...
    (microsoft.public.sharepoint.portalserver)
  • SSO Confiugration and PayStub Sample
    ... I'm trying to get the PayStub sample posted to MSDN ... errors in the event log or in the database. ... "The DataCache database 'Paystubdata' cannot be reached on server ... 'SERVER' with the credentials obtained from SSO. ...
    (microsoft.public.sharepoint.portalserver)