SQL Server 2008 R2

If you use Microsoft Visual Studio to build a .NET-connected application that uses SQL Server Compact 3.5, and you deploy the application in debug mode, the SQL Server Compact 3.5 engine and Query Analyzer are automatically installed on the device. You can also install the Query Analyzer by copying the .cab file to the device. If you are building a native application, you must manually copy the .cab file.

SQL Server Compact 3.5 Query Analyzer requires devices with a touch-screen, such as the Pocket PC or Professional versions. It does not work with non-touch screen devices such as Smart Phone (Windows Mobile 2003 for Smart Phone, Windows Mobile 5.0 for Smart Phone, Windows Mobile 6.0 Standard).

To manually install the Query Analyzer

  1. Install the .NET Compact Framework on the device. Copy the following file to your device:

    C:\Program Files\Microsoft.NET\SDK\CompactFramework\NETCFversion\WindowsCE\platform\processor\NETCFversionplatform.processor.cab.

  2. On the device, click the .cab file to install the .NET Compact Framework.

  3. Copy the sqlce.dev.lang.platform.processor and sqlce.repl.platform.processor.cab file to your device from the following directory:

    %ProgramFiles%\Microsoft SQL Server Compact Edition\v3.5\Devices\platform\processor

    The cab files contains the following:

    The isqlw35.exe a program that implements SQL Server Compact 3.5 Query Analyzer.

    The sqlceoledb35.dll, which is the OLE DB provider for SQL Server Compact.

    The sqlceerr35lang.dll that provides error descriptions for use during development.

  4. On the device, click the .cab file to install the Query Analyzer.

  5. To open Query Analyzer, click Start, click Programs and then click Query Analyzer 3.5.

  6. Alternatively, open the following location on the mobile device and click isqlw35.exe:

    %ProgramFiles%\Microsoft SQL Server Compact Edition\v3.5\EN

Show: