SQL Server ce 2.0 Installation Steps

1. Install SQL Server 2000 (English version );
2. Install SQL Server 2000 SP4;
3. install and configure IIS;
4. Install SQL Server 2000 for ce2.0;
5. Install SQL Server 2000 for ce2.0 SP4. There are many articles on installing SQL Server Ce on the Internet. You can search for many articles and refer to them here: prerequisites:
Evc4.0 (SP2) + standard SDK installed
Take the following steps:
1. Download The sqlce2.0 Installation File, install it, and find the target Folder:
C:/program files/Microsoft SQL Server ce 2.0/device/x86/i486. Note: C:/program files/Microsoft SQL Server ce 2.0/device/x86 contains two folders: emulation and iation. Although sqlce is implemented in the simulator, it uses files in ice. Copy ssce1_dll sscecaw.dll ssceerror20en. DLL to the Windows directory of the simulator and copy dllregister.exe isqlw.exe to the Windows/start up simulator. Note: When selecting the target machine, you need to check the CPU type of the target machine. For example, I chose the ARM/sa1100/folder instead of X86/i8.0;

2. Download adocepbzip, decompress it (this is to extract it to the C root directory), and find
C:/adocepb/Setup/Data Access 3.1/program files/dataaccess31/device/x86/i486/CE/retail. Note that C:/adocepb/Setup/Data Access 3.1/program files/dataaccess31/device does not have the emulation folder, and x86 is used. Copy adoce31.dll adoceoledb31.dll adoxce31.dll to the Windows directory of the simulator.
The same is true here. Select the appropriate file in the folder.
3. Run dllregister.exe on the simulator.
Run the following example after installation: adoce_sample

Reference resources:
Http://blog.vckbase.com/zuilang/archive/2005/09/28/12600.html is simply so a few steps, but encountered some problems, as follows: 1, after the installation of SQL Server is best to use SQL Server and Windows mixed Authentication mode, in the future, it may be easier to synchronize the PDA and SQL Server databases. 2. The default IIS folder must have the shared attribute. Otherwise, the connection configuration will not succeed; 3. The example in the Microsoft SQL Server ce 2.0/samples/EVC directory of SQL Server CE is very important. For details, refer to development.