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
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.
REFERENCES
REFERENCES
SQL Server CE Books Online: topic; "SQL Server CE Query Analyzer Overview"
back to the top
Keywords: kbhowto kbhowtomaster KB304123
