Active X for monitoring a Pull subscription, which one?

Hi all,
I should program a small VisualBasic program for monitoring the status of
the subscription. It is a Pull anonymous subscription to a Snapshot
publication. It is supposed to run at the subscriber, a laptop PC, and
provide info to an human about:
-Wheter the distributor is reachable/available
-The last successful synchronization.
-If the synch is running, the approx time to the end.
I've been browsing around the SQL Replication ActiveX controls available,
but the samples on the Books on Line are focused on how to use the controls
to create the replication, I can't find a sample or indications on how to
monitor a pull subscription at the subscriber. Where can I find some samples
about it? Which control I need?
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
You are probably best to either use the status event or to query the
particular agent's history table in the distribution database for a pull
subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"faustino Dina" <ffdina@.matusa.com.mx> wrote in message
news:ermC9JomEHA.748@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I should program a small VisualBasic program for monitoring the status of
> the subscription. It is a Pull anonymous subscription to a Snapshot
> publication. It is supposed to run at the subscriber, a laptop PC, and
> provide info to an human about:
> -Wheter the distributor is reachable/available
> -The last successful synchronization.
> -If the synch is running, the approx time to the end.
> I've been browsing around the SQL Replication ActiveX controls available,
> but the samples on the Books on Line are focused on how to use the
controls
> to create the replication, I can't find a sample or indications on how to
> monitor a pull subscription at the subscriber. Where can I find some
samples
> about it? Which control I need?
> Thanks in advance
> --
> Faustino Dina
> If my email address starts with two 'f'
> drop the first 'f' when mailing me.
>
|||> You are probably best to either use the status event or to query the
> particular agent's history table in the distribution database for a pull
> subscription.
Yes, ideally I'll show a Progress bar feeded by the status event of one of
the replication controls. Since my publications is a Snapshot one, and
subscription is anonymous pull, I suppose I should use the SqlDistribution
Control but the documentation states it should be used only for
transactional replication so I'm not sure about which other control to use.
The Snapshot control states it should be used for creating snapshot, it is
not the case. The snapshot is already created and ready at the distributor.
And the Merge control is useless on the Snapshot publication I think.