Install and deploy SQL Server compac 3.5 on a PDA device (official edition)

Microsoft Visual Studio 2008 Service Pack 1 (SP1) is used to develop smart device applications for Microsoft SQL Server compact 3.5.Program. Microsoft Visual Studio 2010 does not support the development of smart device applications. However, if Visual Studio 2010 is not installed on your development computer, you may need to upgrade to SQL Server compact 3.5 Service Pack 2 (SP2 ). For more information, seeInstall and deploy SQL Server compact on the desktop). When you deploy a hosted application created in Visual Studio 2008 SP1, SQL Server compact is automatically installed on the smart device. If you use visual c ++ to create a local application in Visual Studio 2008 SP1, you must manually copy the file that will install SQL Server compact on the smart device. For information about 64-bit deployment, seeManage 64-bit database applications.

Important
Visual Studio 2008 SP1 is the preferred environment for developing smart device applications for SQL Server compact 3.5. Visual Studio 2010 does not support the development of smart device applications. For more information, see install the development environment.

Install SQL Server compact 3.5 when deploying hosted applications

When you generate a referenceSystem. Data. sqlserverceWhen you host an application in a namespace and deploy the application to a smart device or a Pocket PC simulation program, Visual Studio automatically checks whether Microsoft is installed on the device. NET Compact framework and SQL Server compact client components. If these components are not detectedSystem. Data. sqlserverceNamespace applications automatically install these components on the device. The default installation location of the SQL Server compact 3.5 client component on the device is % Program Files % \ Microsoft SQL Server compact edition \ v3.5.

To deploy an application to a smart device, click Start debugging in Visual Studio ". Then, select to deploy it to a connected smart device or to a Pocket PC simulation program.

Install SQL Server compact 3.5 when deploying local applications

If Visual Studio 2008 SP1 is used with a smart device project, the SQL Server compact 3.5 and SQL Server compact 3.5 query analyzers are automatically installed. If you use visual c ++ to develop a local application, you must manually install the above components.

You must pass from % ProgramFiles % \ Microsoft SQL Server compact edition \ v3.5 \ devices \Platform\Processor\ Copy the following. cab file and extract it to the root directory of the device. manually copy the SQL Server compact 3.5 and SQL Server compact 3.5 query analyzers to the device:

• Sqlce.Device Type.Platform.Processor. Cab

• Sqlce. Dev.Language.Device Type.Platform.Processor. Cab

• Sqlce. REPL.Device Type.Platform.Processor. Cab

The SQL Server compact 3.5 query analyzer shortcut appears on the "Start" menu of the device.

To start the SQL Server compact 3.5 query analyzer, click the application name in the Start Menu or click the icon on the device.