sqlce exception (27750)

[Kenan]

Hi,

In my application, when I try to delete and recreate sqlce
database, (SOMETIMES) I get an error
(27750:Cannot load sscemw20.dll or ssceca20.dll is
missing or not registered. SSCE_M_SSCEMWFAILURE )

What can be the possible couse of this error?
Thanks...
Kenan

Code that throws exception->

'*****************************
Dim SQLEngine as SqlCeEngine

If Not File.Exists(ceDBSpec) Then
'This line throws sqlceexception(27750)
SQLEngine = New SqlCeEngine("data source=" & ceDBSpec)
SQLEngine.CreateDatabase()

If Not CreateAllTables() Then Return False
If Not CreateAllIndexes() Then Return False
End If
'*****************************

 

[Ilya Tumanov [MS]]

Kenan,

Most likely it's due to low virtual memory. This might be due to several
reasons:
-Your application generated a lot of garbage prior to loading SQL CE, but
not enough to cause collection
-You have another application(s) running and using a lot of memory
-You forget to dispose of objects, allocating native resources (this
includes pretty much all SQL Client and SQL Server CE objects like commands
and connections).

Make sure you disposing of these objects as soon as you do not need them.
Also, you might force collection prior to using SQL CE:

GC.Collect();
GC.WaitForPendingFinalizers();

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------