Installing SQL Server Compact Edition 3.1 on Mobile Device (Pocket PC)

1.) Download the sqlce3.x installer,

http://www.microsoft.com/downloads/details.aspx?FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

or

http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en

2.) Install in your desktop computer.

3.) Navigate to where you installed the sqlce, typically you have to navigate here: C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce400\armv4

4.) You will notice 3 cab files, copy them all to a temporary folder in your pocket

pc using activesync.

5.) Execute (double click) each to install. To check if you have successfully installed the sqlce, in your pocket pc, a directory like this should exist: \Program Files\SQL Mobile\EN

There you go, you have successfully installed the sqlce database on pocket pc.

Note:
The above libraries are compatible with Visual Studio 2005 development.

For Compact Database that was created on code by Visual Studio 2003 you need to install the cab files stored here:
C:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4

sqlce.wce4.armv4 (main database engine)
sqlce.dev.wce4.armv4 (contains query analyzer, etc)
sql.wce4.armv4 (I'm not sure)

If you encounter this problem "you are trying to access an older version of sqlserver compact edition database...". It is very likely that you have created a database in Visual Studio 2003 but deployed the cab files of 2005 or vice versa so watch out.
Installing SQL Server Compact Edition 3.1 on Mobile Device (Pocket PC) Installing SQL Server Compact Edition 3.1 on Mobile Device (Pocket PC) Reviewed by czetsuya on Thursday, September 03, 2009 Rating: 5

No comments:

Powered by Blogger.