I am a little embarrassed about sqlce installation. Why? Since I first learned how to use the. NET companct framework, I have been exposed to sqlce. At that time, there were two difficulties. One is sqlce installation and the other is Program . Of course, today I only want to talk about how to install sqlce.
In fact, there is nothing, sqlce installation is very simple. Because the installation package of sqlce is to install an agent, which is used to establish a server agent for SQL Server to communicate with sqlce on the device, such as (from sqlce book online)
In principle, a management platform called server ce server agent is installed. This platform provides an HTTP connection from SQL Server to the sqlce device. Used for data interaction.
First, let's briefly introduce the point:
1 , SQL Server CE Database Engine ( Database Engine )
SQL CE Database Engine Management Windows CE On the device SQL Server Data. When a small amount of data records change, the database engine can maintain Database Consistency by inserting, updating, and deleting data records, you can use two connection schemes to implement the data synchronization function.
2 , SQL Server CE Customer agent
SQL Server CEThe client proxy is the basic component used for connection on the device. It maintains the following objects: copying objects, Remote Data Access (RDA) Object and engine object. By using these objects, the program can programmatically control theseSQL ServerConnection.
3,SQL Server CEServer proxy
SQL Server CE The server proxy is responsible for handling HTTP Request. After the program sends a request, the customer agent HTTP Send these requests to the server proxy, and the server proxy connects SQL Server And pass HTTP Send the result set to the client proxy. Additional components that are not displayed are also included during this processing, and these components are running IIS .
Merge replication and ( RDA ) Use different methods. HTTP Request, also running IIS Different SQL Server Connect components.
I am a web blind person, so I am not very familiar with some concepts, such as virtual directories, snapshots, and HTTP transmission.
Go back to the point in this article. The first step to install sqlce is to install this server agent. The installation of this agent depends on the version corresponding to the sqlserver version. For example, if your sqlserver2000 version is SP3, you must use the sqlcesp3 version. The sqlserver2000 version is SP4, you must use this version of sqlcesp4. It must be noted that the so-called SP3 and SP4 of sqlserver2000 are patched, the SP3 and SP4 patches are available on the msdn website, and the patch is installed in two parts, for example, sqlserver2000 SP4. The installer first decompress the installation file to the local directory, find the local directory sql2ksp4 and run a batch file setup. BAT, and then proceed according to the installation steps. By the way, you must have installed IIS. Because sqlce and sqlserver are transmitted over HTTP, you know the importance of IIS installation.
Generally, after sqlce is installed, the configuration of SQL Server ce connectivity management is directly entered. The configuration of this connection management platform is to enable Server 2000 to communicate with devices, create a virtual directory pointing to the SQL Server ce Server Agent (sscesaw.dll), determine the HTTP authentication method, and configure NTFS permissions, these configurations are very similar to Web configurations. It is actually an HTTP connection configuration. If you are familiar with the Web, you can easily understand the main points of these actions. The last important option is Set NTFS permissions for the SQL Server snapshot folder. This option is necessary because it can provide a snapshot for data transmission between the server and sqlce, and this snapshot is very necessary. The actual operation is simple but critical. You only need to create a folder under drive C and modify the folder to make it web shared. In this way, you can grant the device the permission to access the snapshot file.
You have completed the installation and configuration steps. Now, you need to enter the http: // 172.0.0.101/sqlce/sscesaw.dll path in the browser, if the words "SQL Server ce Server Agent" appear, you can access the agent on the device. Of course, you must use your own IP address and virtual directory name.
Now you can use Remote Data Access (RDA) and merge replication on the device. Of course, some configuration is required to use merge replication, but this is not covered in today's discussion.
In fact, the installation of sqlce is not very complicated, but it is necessary to describe it in detail. This is of great help to understand the data interaction between Server2000 and sqlce.
