Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-16 : 08:47:23
|
| raj writes "I am using the SQL DMO COM Library with VB.NET for implementing replication between three db servers programmatically. I am trying to implement merge replication where data in one will be pushed into the other two. I used the sample application provided in SQLREPL to implement this. The following is the code for adding a Registered Subscriber to the collection. objRegSubscriber = New RegisteredSubscriber objRegSubscriber.Name = lstTransServers.Items(intIndex).ToString objRegSubscriber.Type = SQLDMO_SUBSCRIBER_TYPE.SQLDMOSubInfo_SQLServer 'Add the subscriber to the Publishers' collection'###############EXCEPTION THROWN########## objPublisher.RegisteredSubscribers.Add(objRegSubscriber)I wrote this code in the morning and tested it. The code worked fine. But later there were some modifications done in the publisher Server, after which the following exception occured :"[SQL-DMO]This property or method is not available until the object (or its parent if appropriate) has been added to a collection."help!!" |
|
|
|
|
|
SQL database replication