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