The first condition for mobile database programming is to build a development environment. My machine uses the Chinese version of vs2005, which comes with the mobile Chinese simulator and SQL ce3.0 Client installation. If you are developing mobile on SQL server2005, you do not need to change it. Since the database server installed on my machine is SQL2000, I need to download the patch package of SQL2000 SP4 first, and then download the installation package of SQL ce2.0 SP4.
After the download is complete, install it on the machine. After the software is installed, a V2.0 directory will be added to the/smartdevices/SDK/SQL Server/Mobile Directory under your vs2005 installation directory, it is installed on mobile of SQL ce2.0.
After the installation is complete, use vs2005 to create a new smartdevice project under VB. NET. After the creation is successful, select project reference. Because vs2005 is installed with SQL ce3.0 by default, and this instance is for mobile development under SQL2000, so select Browse in reference and select system under V2.0 directory in file selection. data. common. DLL and system. data. sqlserverce. DLL files. reference the supported class libraries of SQL ce. After referencing the class library, you need to manage the configuration of the server and mobile simulator.
Server: Install the IIS server, configure a virtual directory sqlce in IIS, and direct the virtual directory to the server directory under the installation directory of SQL ce2.0. After the configuration is complete, select the Server Directory to add read and run permissions for everyone and IIS guests to the directory. Then open the IE page and open the SQL ce2.0 support page http: // localhost/sqlce/sscesa424dll. If the SQL Server ce server agent is displayed, the SQL ce server is successfully configured.
Mobile simulator: to connect the simulator to the database server for Data Reading, you must first connect the simulator to the server. Select Microsoft ActiveSync on the server and select connection settings. In the displayed window, select DMA in the "allow connections to one of the following ports" drop-down box. After confirmation, open the device simulator manager under the vs2005 tool directory. A window will pop up, click the Pocket PC 2003 se simulation program in the window, and select connect under the actions directory. The simulation program starts. Refresh the Manager interface. When the "Pocket PC 2003 se simulation program" icon becomes an arrow, it indicates that the simulator is successfully started. Select the cradle option under actions to start the connection between the simulation program and the server. After the connection is successfully displayed on the Simulator Interface, open the IE page of the simulator and enter http: // server IP Address/sqlce/sscesaw.dll, if the SQL Server ce server agent is displayed, the connection between the simulator and the database server is successful.
