PC Review
Forums
Newsgroups
Microsoft DotNet
Microsoft Dot NET Compact Framework
hint about this sqlceexception? please help
Forums
Newsgroups
Microsoft DotNet
Microsoft Dot NET Compact Framework
hint about this sqlceexception? please help
![]() |
hint about this sqlceexception? please help |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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! |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 "bradbury9" <ray_bradbury9@hotmail.com> wrote in message news:0ad101c34520$eceb4ee0$a301280a@phx.gbl... > 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! |
|
|
|
#3 |
|
Guest
Posts: n/a
|
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: |
|
|
|
#4 |
|
Guest
Posts: n/a
|
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. |
|
|
|
#5 |
|
Guest
Posts: n/a
|
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. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

