Microsoft KB Archive/304123

= HOW TO: Use Query Analyzer on HPC 2000 and Pocket PC 2002 Devices in SQL Server 2000 Windows CE 1.1 =

Article ID: 304123

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft SQL Server 2000 Windows CE Edition 1.1

-



This article was previously published under Q304123



IN THIS TASK
SUMMARY
 * Requirements to Use Pocket PC 2002 with Query Analyzer
 * Requirements to Use HPC 2000 with Query Analyzer
 * Database Manipulation with Query Analyzer

REFERENCES



SUMMARY
SQL Server 2000 Windows CE Edition (SQL Server CE) includes a graphical query analyzer named Isqlwce for Windows CE devices. The Isqlwce utility is installed in the Isqlwce folder of your SQL Server CE installation (by default, Program Files\Microsoft SQL Server CE).

To use Isqlwce, copy the Isqlw_wce.exe file that matches your device type and processor to your Windows CE device.

Only Handheld PC Professional, Palm-size PC, and Pocket PC devices are supported by Isqlwce.

back to the top

Requirements to Use Pocket PC 2002 with Query Analyzer
For Pocket PC 2002, download and apply SQL Server CE 1.1 Service Pack 1 (SP1). For information on how to obtain SQL Server CE 1.1 Service Pack 1, see the following article in the Microsoft Knowledge Base:

316498 INF: How to Obtain the Latest SQL Server 2000 Windows CE Edition 1.1 Service Pack

You can use the Isqlw_wce.exe file for your CPU type that is in the Pocket PC folder located in Program Files\Microsoft SQL Server CE\ISQLWCE.

back to the top

Requirements to Use HPC 2000 with Query Analyzer
For HPC 2000, you can use the Isqlw_wce.exe file for your CPU type that is in the Handheld PC Pro folder located in Program Files\Microsoft SQL Server CE\ISQLWCE. If your device does not already have the Microsoft Foundation Classes (MFC) and OLECE DLL files, you must copy the Mfcce211.dll and Olece211.dll files to the Windows folder on the HPC 2000 device.

For example, to use the query analyzer on a HPC 2000 device with the MIPS processor type, copy Isqlw_wce.exe from the Program Files\Microsoft SQL Server CE\Isqlwce\Handheld PC Pro\MIPS folder to any folder on the HPC 2000 device. Copy the Mfcce211.dll and Olece211.dll files from the Program Files\Microsoft SQL Server CE\Isqlwce\Handheld PC Pro\Mips folder to the Windows folder on the HPC 2000 device.

The Isqlwce utility is a developer tool and is not supported for deployment.

back to the top

Database Manipulation with Query Analyzer
The Query Analyzer for SQL Server CE is a graphical tool that allows you to perform the following tasks after you connect to a database:


 * Query objects by using a SELECT statement.


 * Create tables in a database.


 * Insert and delete rows in a table.


 * Modify existing data in a table.


 * Connect to another database on the device.

back to the top

