SQL Server Programming - sql2005express sub, RMO in vb.net, merge agent status messages

Author

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

S c o t t K r a m e r

2005-12-15, 4:00 am

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!!!

S c o t t K r a m e r

2005-12-18, 3:58 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!!

"S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message
news:16344$43a0ef75$a227293d$17356@ALLTE
L.NET...
>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!!!
>

Sponsored Links