Synchronizing Sql 2005 Compact Edition With SQL 2000

HI ,

I want to synchronize sql 2005 CE edition with SQL 2000.before this i was using sql ce 2.0 and i manage to synchronize with sql 2000.the codes which i used for synch i am specifying below.

Private Const INTERNETURL As String = "http://ihsan/THPMIS/sscesa20.dll"

Private Const PUBLISHERSERVER As String = "IHSAN"

Private Const PUBLISHERDATABASE As String = "THPMIS"

Private Const PUBLISHERSECURITYMODE As SecurityType = SecurityType.NTAuthentication

Private Const PUBLICATION As String = "THPMIS"

Private SUBSCRIBER As String = Dns.GetHostName()

Private Const LOCALDATABASE As String = "My DocumentsTHPMIS.sdf"

'"Provider=microsoft.sqlserver.oledb.ce.2.0;data source=" &

Private Const CONNECTIONSTRING As String = "Provider=Microsoft.SQLSERVER." & _

"OLEDB.CE.2.0;Data Source=" & LOCALDATABASE

Private Const SQLSTRING As String = "Provider=sqloledb;Data Source=IHSAN;Initial Catalog=THPMIS;User ID=sa;Password=sa"



Private Sub ReplicateData()

Dim replicator As New SqlCeReplication

replicator.InternetUrl = INTERNETURL

replicator.Publisher = PUBLISHERSERVER

replicator.PublisherDatabase = PUBLISHERDATABASE

replicator.PublisherSecurityMode = PUBLISHERSECURITYMODE

replicator.Publication = PUBLICATION

replicator.Subscriber = SUBSCRIBER

replicator.SubscriberConnectionString = CONNECTIONSTRING

replicator.Synchronize()

replicator.Dispose()

End Sub

while i am using sql 2000 with sql CE 2005 it is giving an error unknown connection option in connectionstring:provider. can any one give me some suggession how to solve this problem



Best Regards

Ihsan