Folks, it's me once again with the app from Hades I inherited.
VB6, SQLAnywhere, ADO 2.5 with disconnected recordsets and a global
connection. It has a home-grown replication system that bogs down the
system when replication is in progress. I can't do anything about it, since
their system provides a lot of history they need to keep and the
SQLAnywhere's replication ain't too hot.
What I have to do is inform the various users connected to the database when
a synchronization is in progress so they won't panic when the app starts
running a little more slowly. Then, once the synchronization is complete, I
need to inform the users to refresh their data. I had thought I'd keep a
synch status table that the app polled every few minutes, but that seems
kludgy and rather inelegant. So I was wondering if there were a way to
raise an event on the server that would "come back" down on the connection,
or some better method.
Additionally, I can't pop-up message boxes as it would interfere with the
work the users are performing. But I can change the appearance of a button
in a toolbar and put messages in the status bar, so that doesn't worry me.
But again, if you've got any better suggestions, I'd be glad to hear them.