MS SQLCE - Error During Synchronization:While synchronizing data between the PDA and MS SQL Server database

Author

Error During Synchronization:While synchronizing data between the PDA and MS SQL Server database

ashish kumar

2005-09-27, 7:23 am

Hi all...
please have a look at the problem i am facinf regarding the
syncrhonization. please help me for the same.

problem 1:
While synchronizing data between the PDA and MS SQL Server database,
using Active Sync connection, the sync process fails at times and
displays an empty error message box and occasionally it shows the
following exception:

Error During Synchronization:
A native exception occurred.
ExceptionCode:0xc000
0005
ExceptionAddress:0x0
1627b28
Reading: 0x1e000000
OK to terminate
CANCEL to debug

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync
connection drops as soon as the sync process fails. Later when the .SDF
file is deleted and restored the synchronization is successful.
Note: The replication monitor in the SQL Server indicates that the
synchronization was successful even when the above error occurs.

SCENARIO:
Steps to replicate:
1. The PDA is placed on the cradle and a manual connection is
established with the SQL Server database using the guest partnership.
2. The PDA application is invoked. Some data is saved in the local .sdf
file via the application.
3. The User clicks on the “Sync” menu option (Sample code below **) to
start the sync process
4. Most times the sync process is successful. Occasionally the above
issue is encountered.

** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)
Dim ce As SqlCeReplication = Nothing
Try
ce = New SqlCeReplication
'Set Internet properties.
ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"
'Set Publisher properties.
ce.Publisher = vPublisher '"CGH-RSMS"
ce.PublisherLogin = vPublisherLogin '"sa"
ce.PublisherPassword = vPublisherPassword '"xxxxxx"
ce. PublisherSecurityMod
e = SecurityType.DBAuthentication
ce.PublisherNetwork = NetworkType.DefaultNetwork
ce.PublisherDatabase = vPublisherDatabase '"RSMS"
ce.Publication = vPub_Name '"PUB_RSMS"
'Set Subscriber properties.
ce.Subscriber = vSub_Name
ce. SubscriberConnection
String = "Data Source=" & DB_PATH &
vDatabase_Name
If File.Exists(DB_PATH & vDatabase_Name) = False Then
ce. AddSubscription(AddO
ption.CreateDatabase)
End If
ce.Synchronize()
Catch ex As SqlCeException
If vShowMessage = True Then
MsgBox(ex.Message)
End If
Throw ex
Catch ex1 As Exception
If vShowMessage = True Then
MsgBox(ex1.Message)
End If
Throw ex1
Finally
ce = Nothing
End Try
End Sub

-----

problem 2:

29045: Initializing SQL Server Reconciler has failed.

2. On synchronizing the data from the PDA database to the Sql database
on the web system
Then the following Error is popped up.

please help me the way to solve this problem.

Regards,
ashish

*** Sent via Developersdex http://www.droptable.com ***

Arun

2005-09-28, 3:24 am

>29045: Initializing SQL Server Reconciler has failed.
You need to register Sscerp20.dll on IIS machine,

Check out this link,
http://support.microsoft.com/defaul...kb;en-us;814853

Cross post your question in microsoft.public.sqlserver.replication
group to get your problem solved.

Cheers,
Arun.

Sponsored Links