When trying to create the mobile database, you may receive an error: "Could not load file or assembly 'System.Data.SqlServerCE, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies'. The system could not find the file specified." This error means that SQL Server Compact Framework is either missing or corrupt.
To resolve this issue:
- On the InventoryControl client PC where you're attempting to create the mobile database, browse the InventoryControl installation disc, and navigate to: \PROG\Microsoft SQL Server Compact 3.5 sp1\.
- Run SSCERuntime-ENU-x86.msi. If it gives the options to Repair or Remove, select Repair.
- If the error persists, rerun the installer and select Remove, then run it again and select Install.