http://www.sqlmag.com/authors/author/author/5777768/rsscomment/5777768en-USFri, 25 May 2012 09:12:22 GMTFri, 25 May 2012 09:12:22 GMThttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorThu, 02 Dec 2004 04:51:20 GMT
Instead of a sub use a function that returns STATUS_RETURN_CODE. Exampel code in C#: public STATUS_RETURN_CODE ReplicationStatus(string message, int percent) { this.label1.Text = message; this.progressBar1.Value = percent; return STATUS_RETURN_CODE.SUCCESS; }]]>Anonymous User Thu, 02 Dec 2004 04:51:20 GMThttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorhttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorMon, 15 Nov 2004 21:27:52 GMT
I think that the event handler changed between SQL Server 2000 SP2 and SP3. Make sure that you are using SP3. After I upgraded to SP3, it worked for me. Thanks, Glenn Gailey [MS] This information is provided "AS IS" with no warranties, and confers no rights. ]]>GlennGMon, 15 Nov 2004 21:27:52 GMThttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorhttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorTue, 30 Sep 2003 06:10:56 GMT
There is a problem with the code on the following line: AddHandler myMergeObj.Status, New _SQLMergeEvents_StatusEventHandler(AddressOf myMergeObj_Status) Its telling me the following: Method ’Private Sub myMergeObj_Status(message As String, percent As Integer, ByRef retCode As SQLMERGXLib.STATUS_RETURN_CODE)’ does not have the same signature as delegate ’Delegate Function _SQLMergeEvents_StatusEventHandler(Message As String, Percent As Integer) As SQLMERGXLib.STATUS_RETURN_CODE’. AND Method ’myMergeObj_Status’ cannot handle Event ’Status’ because they do not have the same signature. Anyone get this to compile? Thanks, Greg]]>Greg Knierim Tue, 30 Sep 2003 06:10:56 GMThttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorhttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchorFri, 27 Jun 2003 06:46:26 GMT
Just a note about wiring event handlers - the use of ’WithEvents’ and ’Handles’ is enough to wire an event in VB.NET. ’AddHandler’ is a separate way to wire events. In other words, you can use either AddHandler or WithEvents/Handles to wire your Status event. If you decide to use AddHandler you don’t even need to include ’WithEvents’ in your object declaration. See MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconUnderstandingEventHandlers.asp]]>Matt Hostetler Fri, 27 Jun 2003 06:46:26 GMThttp://www.sqlmag.com/article/activex/control-replication-with-activex#commentsAnchor