Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    11

    Unanswered: Any way to notify clients of DB changes?

    Does anyone know of a way to notify clients of database changes in real-time? The clients are non-web clients on a WAN. I would like to fire real-time events in clients when specific data changes. I do not want to implement any type of polling scheme in the clients. Any input would be greatly appreciated!

    Everett
    Everett

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Do you want the notification to go through an email or an actual pop-up on their machine ? Under what conditions would you be sending this ?

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    Use triggers?

  4. #4
    Join Date
    Feb 2002
    Posts
    11
    The notifications would be sent when specified data changes. I can fire a trigger when the data is inserted/updated/deleted, but how can I get this to the clients? I want to fire an event in a VB application, as opposed to sending out an email. For this reason, SQL mail or notification services don't seem to be the right tools to use.

    Everett
    Everett

  5. #5
    Join Date
    Nov 2002
    Posts
    9

    3 ways off the top of my head

    Probably write a COM object and fire a method via a trigger. Look up sp_OACreate in the Books Online.
    Either that or an xp_commandshell and write a command line prog to do the same thing.

    I KNOW the above two would work... If you wanted to get fancy, , you could probably also implement it by having a SQL second connection with read uncommited isoaltion leve that doesn't time out and have the trigger insert to a table that all of the clients are doing a never ending select from. This solution seems interesting, but, is most likely untrodden territory.


    Originally posted by Ev Conrad
    The notifications would be sent when specified data changes. I can fire a trigger when the data is inserted/updated/deleted, but how can I get this to the clients? I want to fire an event in a VB application, as opposed to sending out an email. For this reason, SQL mail or notification services don't seem to be the right tools to use.

    Everett

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •