Re: SQL CE Setup 101... C#
- From: "Manikandan [MSFT]" <manikt@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 13:16:22 +0530
One issue that we can see in your code is that, you ar using IP address in
the Internet Url. We have seen issues when we give IP address in internet
Url on device. Try using the sql server instance name. Also try to browse
from device to make sure that you have the right settings for internet
connectivity
<wayne.small@xxxxxxxx> wrote in message
news:1116475220.584607.310350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
.
- Prev by Date: Re: Sql Mobile 2005 c++ samples (NorthwindOleDb)
- Next by Date: Re: Native Error 0 when replicate sqlce3 with sql server 2000 SP4
- Previous by thread: Re: Sql Mobile 2005 c++ samples (NorthwindOleDb)
- Next by thread: Re: Native Error 0 when replicate sqlce3 with sql server 2000 SP4
- Index(es):
Relevant Pages
|
Loading
