The simplest way to use a Microsoft® SQL Server™ ActiveX® replication control is in conjunction with publications enabled for anonymous subscriptions. Anonymous subscriptions do not require the Subscriber or subscription to be configured at the Publisher. After a publication enabled for anonymous subscriptions is created, an application using a ActiveX replication control can synchronize with the publication data.
This example demonstrates how a Microsoft® Visual Basic® program can configure the SQL Distribution control to synchronize data with an anonymous SQL Server Subscriber:
'Synchronize the data
oSQLDistribution.Initialize
oSQLDistribution.Run
oSQLDistribution.Terminate
Note The above properties are the same for both the SQL Merge and SQL Distribution controls. You can replace references to the SQLDistribution object with references to the SQLMerge object.
Adding an Anonymous Subscription