SQL CE Setup 101... C#



I continue to receive the following message...
"The remote server does not exist or has not been designated as a valid
Publisher." along with "Initializing SQL Server Reconciler has failed.
[,,,,,]".
I know this question has been asked several times in the past and I
have read each and every article over the past two days with no avail.
I trying to set up replication between the server (my laptop) named
RAD1 has both sql and iis on it, and my pocket pc.

I am VERY new to mobile development.

Steps that I have taken:
*Permisssioned the snapshot directory for the RAD1\RAD1_IUSR account.
*Re-registered the sscerp20.dll and subsequently restarted IIS.
*Changed the snapshot directory to d:/snapshot and re-permissioned.
*Allow for anonymous access from an IIS perspective.
*I have created the publication and started the agent to create the
snapshot ( I can see the files in the directory and the screen in
enterprise manager shows A snapshot of 11 article(s) was generated.

Here's the actual code... right out of BOL other than I included a
check to delete the sdf file as that was throwing an exception on the
2nd runthrough.

SqlCeReplication repl = null;

try
{
// Set the Replication object.
if(File.Exists("\\my documents\\ssce.sdf"))
File.Delete("\\my documents\\ssce.sdf");
repl = new SqlCeReplication();
repl.InternetUrl = "http://192.168.2.102/sqlce/sscesa20.dll";;
repl.InternetLogin = "";
repl.InternetPassword = "";
repl.Publisher = "192.168.2.102";
repl.PublisherDatabase = "IncontrolNew";
repl.PublisherLogin = "icuser";
repl.PublisherPassword = "icuser";
repl.Publication = "IncontrolNew";
repl.SubscriberConnectionString =
"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\\my
documents\\ssce.sdf";
repl.Subscriber = "PDT8100_2002";

// Create the Local SSCE Database subscription.
repl.AddSubscription(AddOption.CreateDatabase);

// Synchronize to the instance of SQL Server 2000 to populate the
Subscription.
repl.Synchronize();
}
catch(SqlCeException x)
{
// Use your own error handling routine to show error information.
MessageBox.Show(x.Message.ToString(),"Error subscription problem");
// ShowError.ShowErrors(e);
}
finally
{
// Dispose of the Replication object.
repl.Dispose();
}


IncontrolNew is the database the ip address is the ip addy to the
laptop(SERVER). icuser is dbo on the database. I have the subsriber set
to PDT8100_2002 - the device name of the handheld... hopefully I have
found that properly.

I have read the microsoft documents and haven't been able to implement
anything to help get me through this piece of the puzzle. Any help or
ideas would be greatly appreciated as I am about ready to write my own
sync routine updating the remote source and local source manually (you
know I don't want to go through that) or trying to use some XML
functionality in conjunction with ActiveSync.

.



Relevant Pages


Loading