Database SQLce on WinCE Net 6.0

SQL CE on WinCE Net 6.0

There is a lot of questions about installation of the Microsoft SQL Server Compact Edition on WinCe Net device.

Can we install SQLce on WinCe Net 6.0 ? Yes we can.

OK - have a look at the example of the installation SQLce 3.5 on Toshiba JournE Touch.

A) What do we need for installation ?

1. First of all you need to install Total Commander or UIJS where you can open also Total Commander.

Look at:
http://mobiledev-jans.blogspot.com/2011/04/toshiba-journe-touch-plny-pristup.html

2. You need three cab files:
sqlce.wce5.armv4i.CAB
sqlce.dev.ENU.wce5.armv4i.CAB
sqlce.repl.wce5.armv4i.CAB

Download them below - red link.

Very important is
sqlce.wce5.armv4i.CAB
You need to install this file.

If you want use also Query Analyzer install also:
sqlce.dev.ENU.wce5.armv4i.CAB
sqlce.repl.wce5.armv4i.CAB

3. If you use some program with *.sdf (SQLce database) you need to copy to the WinCe Net device minimal three another files:
*.exe file of your program
*.sdf database file
System.Data.SqlServerCe.dll - this file you can find in "\bin\Release" directory after program compilation in Visual Studio 2008.

B) How to do the installation ?

I assume you have got Total Commander or UIJS on your device.
1.
Download three SQLce 3.5 cab files from this link:

Download SQLce35

Unzip an copy to your WinCe Net device.

2.
First of all install:
sqlce.wce5.armv4i.CAB
But be careful - during the installation you must choose no Program Files in Root of the device.
You must choose "\Journe Touch\Program Files".
After installation there will be "Microsoft SQL Server Compact Edition" in the "\Journe Touch\Program Files" directory. It remains also after Off-On the device.
Now you can use the programs created in Visual Studio 2008 with the *.sdf database.
Do not miss "System.Data.SqlServerCe.dll" file copy where is the "exe" and "sdf" file.

3.
If you want to use also Query Analyzer, install also :
sqlce.dev.ENU.wce5.armv4i.CAB
sqlce.repl.wce5.armv4i.CAB

But be careful - during the installation you must choose no Program Files in Root of the device.
You must choose "\Journe Touch\Program Files".
Also I recommend rename "Microsoft SQL Server Compact Edition" to "Microsoft SQL Server Compact EditionDev" during the installation.
After installation there will be "Microsoft SQL Server Compact EditionDev" in the "\Journe Touch\Program Files" directory. It remains also after Off-On the device.

You can use this way of the SQLce 3.5 installation also to the another WinCe Net device.

Enjoy
JS