SQL Server CE "module could not be found" Crash

Question

We are getting following error message in one Windows XP - X86

Exception Source:      System.Data.SqlServerCe
Exception Type:        System.DllNotFoundException
Exception Message:     Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Exception Target Site: DllAddRef

SQL Server CE installed and the application is compiled as X86 running OS is X86 as well.

Any idea why this might happen?

Normally this works almost perfectly in most of the computers, but doesn't work on this one computer.

Answer 1

You must install the replication components on the device, this cab file contains the compaction dll: sqlce3x.repl.[platform].[processor].cab

Answer 2

Compile your application for 'Any CPU', then it will use the according x86/x64 libraries automatically.