Can’t find P/Invoke DLL sqlcemeNN.dll

I know this is very annoying, uninformative, directionless…blah blah… error.   And, kindly pardon me for blogging about this error very lately.   Better late than never and here it goes.   What are the actual errors? 1) Can’t find P/Invoke DLL sqlceme30.dll 2) Can’t find P/Invoke DLL sqlceme35.dll 3) Can’t find P/Invoke DLL sqlceme40.dll   What…

19

Troubleshooting: Can’t load sqlce dll

  SQL Server CE/Comapct uses Windows API LoadLibrary (PlatformBuilder or WinCE or Win32) to load the DLLs.   When LoadLibrary fails to load any SQL CE dll, we throw the error “Can’t load sqlce dll”.   Now, let’s discuss more on why LoadLibrary can fail.    1)      Virtual Memory is too low to load the dll 2)  …

4

SqlCeEngine/ISSCEEngine: Shrink Vs Compact

  The difference between these two is much similar to Internal and External Memory Fragmentation.  From SqlCeEngine.Shrink documentation, Reclaims wasted space in the database by moving empty and unallocated pages to the end of the file, and then truncating the file.  You can configure a database to automatically shrink by setting the autoshrink threshold option…

3