Re: ADO, VB6, SQL Server: How do I receive database change notification events ?

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

From: Val Mazur (group51a_at_hotmail.com)
Date: 03/23/04 

Date: Mon, 22 Mar 2004 22:35:10 -0500

Hi Massimo,

No, there is no easy way to implement it. Even if your trigger will fine on a change in a table, this trigger will not fire anything outside of the database and client will not get any notification. Simplest way is to implement triggers, which will set some field in another table, which would indicate changes. Then, from the client side, check this table once in a while 

-- 
Val Mazur
Microsoft MVP
  "Massimo Conti" <mconti@ceia-spa.com> wrote in message news:OvEpUTAEEHA.3080@TK2MSFTNGP10.phx.gbl...
  Hello,
  Is it possible to receive database change notification events in VB, using ADO, from SQL Server ?
  I know SQL Server has triggers able to to this... but how can i binding ADO with Triggers, 
  in order to recieve data change notification events, without polling the table continuously ?
  Thanks in advance.
  Massimo Conti.

Relevant Pages

  • ADO, VB6, SQL Server: How do I receive database change notification events ?
    ... Is it possible to receive database change notification events in VB, using ADO, from SQL Server? ...
    (microsoft.public.vb.database.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)