Hi
I have this:
Pocket PC 3.011171
Windows XP Home Edition
Installed: Microsoft Visual Studio .NET 2003
Microsoft ActiveSync 3.5
Windows Server 2000
Installed: Microsoft SQL Server 2000
Microsoft SQL Server CE 2.0
IIS 5.0
The XP and the 2000 are in a LAN and the Pocket PC is linked to the XP
with usb to Active Sync 3.5. I want to know how to set up an easy, very easy
replication and start developing. I have not been able to find a good
tutorial, and I'm having some problems. My application gives me an error,
below is the code under a button click, the only code I have in the
application.
On the SQL 2000 I have made a publication of a simple DB, in IIS I have a
virtual directory containing the sscesa20.dll. Can anyone help me? Maybe
it's not possible to develop on my XP with the SQL Server CE 2.0 on the
Windows 2000 machine?
Tim
The Code:
Dim rep As SqlServerCe.SqlCeReplication
rep = New SqlServerCe.SqlCeReplication
rep.InternetUrl = "http://1.50.105.75/testSQLCE/sscesa20.dll"
rep.InternetLogin = ""
rep.InternetPassword = ""
rep.Publisher = "BALDER"
rep.PublisherDatabase = "ContactManagement"
rep.PublisherLogin = "sa"
rep.PublisherPassword = ""
rep.Publication = "ConatctManagement"
rep.Subscriber = "test"
rep.SubscriberConnectionString =
"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My
Documents\DatamanRep.sdf"
rep.AddSubscription(SqlServerCe.AddOption.CreateDatabase)
rep.Synchronize()