In order to distribute a program release, I've installed SQL CE by its sqlce.wce5.armv4i.CAB on a PicoMod3 device.
I've set the install path to FFSDISK and launched reg save after setup completed.
Everything works ok, but, after switching off and on the device, my application can't find the assemby SqlServerCe any more.
Is there a particular procedure to follow in order to install an application permanently? Thank you.
SQL CE doesn't stay installed after device reboot
-
-
Hello,
maybe CAB file cause an error (set somewere "window" were should set "ffsdisk")? You can investigate/modify CAB using a tool (e.g. WCE CAB Manager from OCP http://www.ocpsoftware.com/). If you install DLLs in a subdirectory of ffsdisk please check if it helps to set this directory as additional search path: -
I've tried to do as you suggest but, when restarting Windows CE, i get the same error: the message "File or assembly name System.Data.SqlServerCe or one of its dependencies was not found" appear when I open my program. This don't happen immediatly after installing SQL CE.
Something changes after Windows CE restart. -
Hello,
are following files in \FFSDISK\MicrosoftSQLServerCompactEdition\v3.5? Else search them at RAM and copy them!
Register should be similar:Code- reg open \SOFTWARE\Apps
- reg create key "SQLServerCompact 3.5 Core"
- reg set value Instl dword 1
- reg set value IsvFile string "\Windows\AppMgr\SQLServerCompact 3.5 Core.DLL"
- reg set value CmdFile string "\Windows\AppMgr\SQLServerCompact 3.5 Core.DAT"
- reg set value CabFile string "sqlce.wce5.armv4i.CAB"
- reg set value InstlDirCnt dword 1
- reg set value InstallDir string "\FFSDISK\MicrosoftSQLServerCompactEdition"
- reg set value InstlDir string "\FFSDISK\MicrosoftSQLServerCompactEdition"
- reg open \SOFTWARE\Microsoft
- reg create key "MicrosoftSQLServerCompactEdition"
- reg create key v3.5
- reg set value BuildMinor dword 0
- reg set value BuildMajor dword 0x163c
- reg set value ServicePackLevel dword 1
- reg set value Version string "3.5.5692.0"
- reg set value NativeDir string "\FFSDISK\MicrosoftSQLServerCompactEdition\v3.5"
- reg set value InstallDir string "\FFSDISK\MicrosoftSQLServerCompactEdition\v3.5"
- reg open "\SOFTWARE\Microsoft\.NETCompactFramework\Installer\Assemblies\Global"
- reg set value "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3" multi "\ffsdisk\MicrosoftSQLServerCompactEdition\v3.5\GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll"
- reg open \Loader
- reg set value SystemPath multi \ffsdisk\;\FFSDISK\MicrosoftSQLServerCompactEdition\v3.5"
- reg save
-
I've tried also this last solution but I still can't solve the problem...
-
Hello,
QuoteI've tried also this last solution but I still can't solve the problem...
Then you have to invastigate CAB file with WCE CAB Manager from OCP (see link above).
-
I've created a new CAB with \FFSDISK\MicrosoftSQLServerCompactEdition\v3.5 as Default Install Dir as you suggest in your first post but didn't solve my problem..
-
Hm,
can you send my CAB and simple VS project by mail. I will try to find discrepancies. -
Hello,
thanks for you CAB file and sample.I check it an find following problems:
- GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll is installed into windows please copy it into the install directory.
- Under HKLM\software\microsoft\.NetCompactFramework\installer\assamblies\global value "System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=3BE235DF1C8D2AD3" refers also to windows. Please set here the (multi) data to
\ffsdisk\MicrosoftSQLServerCompactEdition\v3.5\GAC_System.Data.SqlServerCe_v3_5_1_0_cneutral_1.dll
\ffsdisk\MicrosoftSQLServerCompactEdition\v3.5\System.Data.SqlServerCe.dll
than is works. If you did not see the data correct using OCP tool please use ndcucfg or remote registry editor.