"Ed Santosusso" <EdSantosusso@discussions.microsoft.com> wrote in message
news:1C427B19-1E03-4403-B757-7EF1EDDEC04A@microsoft.com...
>I have two publications on a SQL Server 2000 database.
> I am able to create two subscriptions from another SQL Server 2000
> database
> and synchronize both in succession.
>
> However when I try to repeat this going from SQL Server 2000 to SQLCE 2.0
> it fails. The first goes OK. The second fails.
> I get error 80004005, 28521 (The SQL Server CE database is already enabled
> for publication.
> Is it possible to do what I am trying to do on CE?
>
> The reason I have 2 publications is because the first is non-filtered and
> goes very fast via bcp files.
> The second is dynamically filtered and not as fast. Breaking them up makes
> reinits go much faster.
>
> My code is included below.
>
> Thanks
> Ed Santosusso
> esantosusso@omicron.com
>
> --------------------------------------------------------
>
> // Create and initialize the Replication object
>
> hr = CoCreateInstance(CLSID_Replication, NULL, CLSCTX_INPROC_SERVER,
> IID_ISSCEMerge, (LPVOID *)&CEMerge);
> CEMerge->put_InternetURL(L"http://myiisserver/sqlce20/sscesa20.dll");
> CEMerge->put_InternetLogin(L"<userid>");
> CEMerge->put_InternetPassword(L"<password>");
> CEMerge->put_Publisher(L"mysqlserver");
> CEMerge->put_PublisherDatabase(L"MyDataBase");
>
> CEMerge->put_Publication(L"Publication1");
> CEMerge->put_PublisherSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
> CEMerge->put_PublisherLogin(L"sa");
> CEMerge->put_PublisherPassword(L"mypassword");
> CEMerge->put_PublisherNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
> CEMerge->put_Subscriber(L"TestReplAndMerge");
> CEMerge->put_SubscriberConnectionString
> (L"Provider=microsoft.sqlserver.oledb.ce.2.0;Data
> Source=\\mydatabase.sdf");
> CEMerge->put_Distributor(L"mysqlserver");
> CEMerge->put_DistributorNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
> CEMerge->put_DistributorSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
> CEMerge->put_DistributorLogin(L"sa");
> CEMerge->put_DistributorPassword(L"mypassword");
> CEMerge->put_HostName(L"some host name");
> CEMerge->put_ExchangeType((REPL_EXCHANGE_TYPE)BIDIRECTIONAL);
> CEMerge->put_Validate(NO_VALIDATION);
>
>
> bool NewFile = false;
>
> // see if we need a file
>
>
> if (FileExists(L"\\mydatabase.sdf") == false)
> {
> hr = CEMerge->AddSubscription(CREATE_DATABASE);
>
> if (!SUCCEEDED(hr))
> {
> ShowMergeErrors(L"Add Subscription failed",CEMerge);
> return 0;
> }
> NewFile = true;
> }
>
>
> hr = CEMerge->Initialize();
>
> if (!SUCCEEDED(hr)) {
> ShowMergeErrors(L"Static Merge Initialize failed",CEMerge);
> return 0;
> }
>
> hr = CEMerge->Run();
> if (!SUCCEEDED(hr)) {
> ShowMergeErrors(L"Static Merge Run failed",CEMerge);
> return 0;
> }
>
>
> // Destroy the Replication object
> if (CEMerge)
> CEMerge->Release();
>
>
>
> // set up for Second Merge
>
> // Create and initialize the Replication object
> hr = CoCreateInstance(CLSID_Replication, NULL, CLSCTX_INPROC_SERVER,
> IID_ISSCEMerge, (LPVOID *)&CEMerge2);
> CEMerge2->put_InternetURL(L"http://myiisserver/sqlce20/sscesa20.dll");
> CEMerge2->put_InternetLogin(L"<userid>");
> CEMerge2->put_InternetPassword(L"<password>");
> CEMerge2->put_Publisher(L"mysqlserver");
> CEMerge2->put_PublisherDatabase(L"MyDataBase");
>
> CEMerge2->put_Publication(L"Publication2");
> CEMerge2->put_PublisherSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
> CEMerge2->put_PublisherLogin(L"sa");
> CEMerge2->put_PublisherPassword(L"mypassword");
> CEMerge2->put_PublisherNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
> CEMerge2->put_Subscriber(L"TestReplAndMerge");
> CEMerge2->put_SubscriberConnectionString
> (L"Provider=microsoft.sqlserver.oledb.ce.2.0;Data
> Source=\\mydatabase.sdf");
> CEMerge2->put_Distributor(L"mysqlserver");
> CEMerge2->put_DistributorNetwork((REPL_NETWORK_TYPE)DEFAULT_NETWORK);
> CEMerge2->put_DistributorSecurityMode((REPL_SECURITY_TYPE)DB_AUTHENTICATION);
> CEMerge2->put_DistributorLogin(L"sa");
> CEMerge2->put_DistributorPassword(L"mypassword");
> CEMerge2->put_HostName(L"some host name");
> CEMerge2->put_ExchangeType((REPL_EXCHANGE_TYPE)BIDIRECTIONAL);
> CEMerge2->put_Validate(NO_VALIDATION);
>
>
> if (NewFile)
> {
> hr = CEMerge2->AddSubscription(EXISTING_DATABASE);
>
> if (!SUCCEEDED(hr))
> {
> ShowMergeErrors(L"Add Subscription failed",CEMerge2);
> return 0;
> }
> }
>
>
> hr = CEMerge2->Initialize();
>
> if (!SUCCEEDED(hr)) {
> ShowMergeErrors(L"Tech Merge Initialize failed",CEMerge2);
> return 0;
> }
>
> hr = CEMerge2->Run();
> if (!SUCCEEDED(hr)) {
> ShowMergeErrors(L"Tech Merge Run failed",CEMerge2);
> return 0;
> }
>
>
> // Destroy the Replication object
> if (CEMerge2)
> CEMerge2->Release();
>
>
>