Install SQL Server compact on a PDA device

How to select the correct SQL Server compact installation package Abstract: the SQL Server compact installation package consists of three functions and distinguishes between the CPU platform and the operating system platform. Beginners often do not know how to distinguish them. This article introduces the installation packages of SQL Server compact, so that you can know how to distinguish and select them.

If you are using Visual Studio 2005/2008 to develop. NET Compact framework applicationsProgramAnd the SQL Server compact database is used in the program. When Visual Studio deploys your program to a device (or simulator), it will automatically deploy SQL Server compact together. If you develop native code applications, You need to manually deploy the SQL Server compact installation package. In addition, you also need to manually deploy SQL Server compact when deploying applications for end users devices.

The installation packages of SQL Server Compact are stored in the following locations, which are currently called the "root directory" of the installation package ":

Version Number	Path
3.0/3.1	% Program Files % \ Microsoft Visual Studio 8 \ smartdevices \ SDK \ SQL Server \ mobile \ V3.0
3.5	% Program Files % \ Microsoft SQL Server compact edition \ v3.5 \ Devices

The root directory contains two subdirectories: wce400 and wce500, which respectively store the installation packages for the operating system platform with Windows CE 4.0 and Windows CE 5.0 as the kernel. The SQL Server compact installation packages for Windows Mobile 2003 and Windows CE 4.0 are in the wce400 directory; the Windows Mobile 5.0/6.0/6.1 and Windows CE 5.0/6.0 SQL Server compact installation packages are in the wce500 directory.

Directory	Platform
Wce400	Windows Mobile 2003, Windows CE 4.0
Wce500	Windows Mobile 5.0/6.0/6.1, Windows CE 5.0/6.0

Open the wce500 directory, and you can see some subdirectories named after the processor. The directory names are armv4i, misiⅱ, misii_fp, misiv, misiv_fp, sh4, and x86. The CPU of Windows Mobile devices generally belongs to armv4i, while Windows CE depends on the specific hardware.

Open the armv4i directory and you can see some. CAB files. The following table describes the functions and application platform of each installation package file based on SQL Server compact 3.1:

Installation Package	Platform	Function
Sqlce30.wce5. armv4i. Cab	Windows CE	Engine
Sqlce30.ppc. wce5.armv4i. Cab	Windows Mobile Pocket PC	Engine
Sqlce30.phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Engine
Sqlce30.repl. wce5.armv4i. Cab	Windows CE	Merge replication
Sqlce30.repl. PPC. wce5.armv4i. Cab	Windows Mobile Pocket PC	Merge replication
Sqlce30.repl. Phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Merge replication
Sqlce30.dev. enu. wce5.armv4i. Cab	Windows CE	Query Analyzer
Sqlce30.dev. enu. PPC. wce5.armv4i. Cab	Windows Mobile Pocket PC	Query Analyzer
Sqlce30.dev. enu. Phone. wce5.armv4i. Cab	Windows Mobile Smartphone	Query Analyzer

From the table above, we can see that the installation package of SQL Server compact is divided into three functions: Engine, merge replication and query analyzer, each of which is divided into Windows CE, windows Mobile pocketpc and Windows Mobile Smartphone. Therefore, the armv4i directory contains nine. Cab installation packages. In many cases, you only need to install the engine. If you need to enable SQL Server compact to support RDA or merge replication data synchronization, you need to install the merge replication component; if you want to directly use the query analyzer on your device to create, open, and query the SQL Server compact database, or debug programs on your device, you need to install the query analyzer component. That is to say, the engine component is required, and the merge replication and query analyzer components are optional.

Each component installation package contains different files, which are listed in the following table:

Installation Package	include files
sqlce. platform. processor . Cab	sqlcese30.dll sqlceqp30.dll sqlceme30.dll system. Data. sqlserverce. dll
sqlce30.repl. platform. processor . Cab	sqlceca30.dll sqlceoledb30.dll sqlcecompact30.dll
sqlce30.dev. Lang . platform. processor . cab	isqlw30.exe sqlceerr30 Lang . dll

If your device cannot run normally after SQL Server compact is installed, check whether the correct version is installed?