hint about this sqlceexception? please help

  • Thread starter Thread starter bradbury9
  • Start date Start date
B

bradbury9

I have tried both constructors of class SqlCeReplication
I tried the non-parameters one (CEMerge = New
SqlCeReplication) and failed.
Then I commented that lien Iand tried the full-parameter
one (CEMerge = New SqlCeReplication(strInternetURLDflt,
strInt...) and also failed.
sqlceexception.message doesn't return any text nor error
code.

At the try-catch i have this code:
---------------------
CEMege=Nothing
try
'CEMerge = New SqlCeReplication(strInternetURLDflt,
strInternetLoginDflt, strInternetPasswordDflt,
strPublisherNameDflt, strServerDatabaseNameDflt,
strDatabaseUserIdDflt, strPublisherPasswordDflt,
strServerPublicationNameDflt, strSuscriberNameDflt,
strConnectionStr)
CEMerge = New SqlCeReplication
catch sqlceeenception ex
MsgBox("Error(0): " & ex.Errors(0).Message & "
number: " & ex.Errors(0).HResult)
end try
---------------------

The output is the following in both constructors
---------------------
Error(0): Number: 134234117


Any Ideas? I worked fine for several weeks and the sql
server has had no changes!
 
you have to examine the inner exception. Use this function :

Public Shared Sub DisplaySQLCEErrors(ByVal ex As SqlCeException)
Dim i As Integer
For i = 0 To ex.Errors.Count - 1
MessageBox.Show("Error Index #" & i & vbCrLf & _
"Error: " + ex.Errors(i).ToString())
Next
End Sub
 
I have used the following code to get the exceptin details:
-------------------------------------------
Dim ErrorString As String
If 0 >= sqlex.Errors.Count Then
MessageBox.Show("SqlCeException but no count of
errors.")
Else
Dim i As Integer
For i = 0 To sqlex.Errors.Count - 1
Dim l As Integer = i + 1
ErrorString = "Error " & l & " of " &
sqlex.Errors.Count & vbCrLf
ErrorString = ErrorString & "HR: " & sqlex.Errors
(i).HResult & vbCrLf
ErrorString = ErrorString & "Native Error: " &
sqlex.Errors(i).NativeError & vbCrLf
ErrorString = ErrorString & "Message: " &
sqlex.Errors(i).Message & vbCrLf
ErrorString = ErrorString & "Source: " &
sqlex.Errors(i).Source & vbCrLf
Dim j As Integer
For j = 0 To sqlex.Errors
(i).NumericErrorParameters.Length - 1
l = j + 1
ErrorString = ErrorString & "Parameter " & l
& ": " & sqlex.Errors(i).NumericErrorParameters(j) & vbCrLf
Next
Dim k As Integer
For k = 0 To sqlex.Errors(i).ErrorParameters.Length - 1
l = k + 4
ErrorString = ErrorString & "Parameter " & l
& ": " & sqlex.Errors(i).ErrorParameters(k) & vbCrLf
Next
MessageBox.Show(ErrorString, "SQL CE Errors")
Next
End If

-------------------------------------------------------
HR: 134234117
Native Error: 27750
Message:
Source:
Parameter 1: 0
Parameter 2: 0
Parameter 3: 0
Parameter 4:
Parameter 5:
Parameter 6:
 
Did you register or have the appropriate dll's
the intepretation of that error is

"Cannot load sscemw20.dll or ssceca20.dll is missing or not registered."
This posting is provided "AS IS" with no warranties, and confers no rights.
 
I also hit this problem whenever I call SqlCeRemoteDataAccess after
retrieve the data using SqlCeConnection And SqlCeCommand. If I don't
retrieve the data, the SqlCeRemoteDataAccess is just works fine.
 
Back
Top