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:0xc0000005
ExceptionAddress:0x01627b28
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.
========================================================
** 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
ce.PublisherLogin = vPublisherLogin '"sa"
ce.PublisherPassword = vPublisherPassword '"xxxxxx"
ce.PublisherSecurityMode = SecurityType.DBAuthentication
ce.PublisherNetwork = NetworkType.DefaultNetwork
ce.PublisherDatabase = vPublisherDatabase
ce.Publication = vPub_Name
'Set Subscriber properties.
ce.Subscriber = vSub_Name
ce.SubscriberConnectionString = "Data Source=" & DB_PATH & vDatabase_Name
If File.Exists(DB_PATH & vDatabase_Name) = False Then
ce.AddSubscription(AddOption.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
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96703
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96832
Thanks,
Laxmi NRO, MSFT, SQL Mobile
