Could not load sqlcecompact30.dll

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yong Ling - 17 Apr 2008 05:38 GMT

Hi,

When I try to exit my program in PDA.
it give me the error below.

RealTimmeMobileSys.exe
SqlCeException
Could not load sqlcecompact30.dll. Operation has been aborted.

at System.Data.SqlServerCe.SqlCeEngine.ProcessResults()
at System.Data.SqlServerCe.SqlCeEngine.Repair()
at System.Data.SqlServerCe.SqlCeEngine.Compact()
at DAL.DatabaseCe.CompactDatabase()
at DAL.DatabaseCe.DeInitialise()
at RealTimmeMobileSys.MainProgram.DeInitialise()
at RealTimmeMobileSys.MainProgram.Main()

This didn't happen every time.
I wonder what's going on.

Thanks in advance.
Yong Ling

Reply to this Message

Ginny Caughey MVP - 17 Apr 2008 14:16 GMT

Usually when you get an error message indicating that you can't load a SQL
Compact dll sometimes but not every time, so you know the DLL is there, the
problem is that there is no longer enough room to load the native DLL. If
this is the case, then causing the DLL to load early in your app's
executution by referencing a type in that DLL should fix the problem.

Ginny

> Hi,
>
[quoted text clipped - 18 lines]
> Thanks in advance.
> Yong Ling

Signature

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Software for Waste Management

Reply to this Message

paul.diston@skillweb.co.uk - 29 May 2008 15:44 GMT

Hi,

I was wondering whether you could tell me how you can determine that
you no longer have enough room to load the native DLL. I am
experiencing the same problem however I am sure I have enough room to
load the DLL.

Thanks

Paul

Reply to this Message

Ginny Caughey MVP - 29 May 2008 15:55 GMT

Paul,

It's sort of through the process of elimination. If you write a tiny app
that doesn't do much more than use a type that would be required by the
unmanaged DLL and that one works - then your bigger app probably has the
space problem. If that's the case, using a type which gets the DLL loaded
very early in your big app's execution will generally work.

Ginny Caughey
Device Development MVP

> Hi,
>
[quoted text clipped - 6 lines]
>
> Paul

Reply to this Message

paul.diston@skillweb.co.uk - 29 May 2008 17:18 GMT

Hi,

I am seeing some very strange results. If I explain my scenario then
maybe you could shed some light on it.

We use SQL CE to store some XML data, however before we insert this
data we delete the existing data and then compact the database, we
then insert the new XML data and then upload some XML data to a
server, this uploaded XML data is then deleted and then we compact the
database.

In both the above compactions the 'could not load sqlcecompact30.dll'
exception occurs.

Further along in the application process, we insert some more data
into the database, after a certain period we then upload this data to
the server as above and then compact the database.

In this compaction the 'could not load sqlcecompact30.dll' exception
DOES NOT occur.

As you can see this is inconsistent, if there was a space problem then
all compactions should fail.

Can you think of a reason why I may be seeing these results.

Thanks in advance.

Paul Diston

Reply to this Message

Ginny Caughey MVP - 29 May 2008 17:56 GMT

Paul,

I agree with your logic, and I don't see any obvious reason why you
sometimes get the message and sometimes don't.

Ginny

> Hi,
>
[quoted text clipped - 25 lines]
>
> Paul Diston

Reply to this Message

paul.diston@skillweb.co.uk - 29 May 2008 17:19 GMT

Reply to this Message