sql server programming: sql2005express sub, RMO in vb.net, merge agent status messages -- sql server programming

sql2005express sub, RMO in vb.net, merge agent status messages

S c o t t K r a m e r
12/14/2005 11:22:14 PM

sql server programming:

I can create, drop reint, & sync just fine (I built a small widget
like vb.net 2005 form)

However I can't figure out how to get status events out of the running
agent... I need to drive a progress bar & update a textbox with messages
while it's syncing

there's sample code in C#, (salesorders.cs), but not vb.net

I'll keep plugging away, but can't seem to get it to fly--

could some give me some pointers on how to structure this in vbnet?

thanks!!!

Re: sql2005express sub, RMO in vb.net, merge agent status messages

S c o t t K r a m e r
12/18/2005 2:09:33 AM

http://msdn2.microsoft.com/ms147890.aspx

Obtain an instance of the MergeSynchronizationAgent class from the
SynchronizationAgent property, and call the Synchronize method. This method
starts the Merge Agent synchronously, and control remains with the running
agent job. During synchronous execution, you can handle the Status event
while the agent is running.

I can't figure out how to handle the Status event... it's a matter of how
to stucture the code (in vb)

Could someone help me with some pointers, or structure of code this is
expecting?

Thanks!!

[quoted text, click to view]