Sample Applications and Client Interfaces
English Query includes several sample applications and sample client interfaces, which you can modify for your own applications.
Sample English Query Models
English Query includes several sample models in the following folders in \Program Files\Microsoft English Query\Samples\Models:
Contains a sample English Query model for the Microsoft® SQL Server™ pubs sample database.
Contains a model for the Northwind sample database, distributed with SQL Server version 7.0 and SQL Server 2000.
Contains a model for the FoodMart sample OLAP database, distributed with SQL Server OLAP Services version 7.0, and FoodMart 2000, distributed with SQL Server 2000 Analysis Services.
Sample Client User Interfaces
English Query includes several sample client user interfaces, which can be modified to create your own English Query applications. These interfaces appear in \Program Files\Microsoft English Query\Samples\Applications in the following locations:
Contains a complete Active Server Pages (ASP) sample application for English Query. It requires Microsoft Internet Information Server version 3.0 or later.
Contains a sample Microsoft Visual Basic® application for English Query. It requires Visual Basic version 6.0 or later and either the PivotTable or FlexGrid control.
Contains a sample Microsoft Visual C++® application for English Query. It requires Visual C++ version 6.0 or later and either the PivotTable or FlexGrid control.
The ASP application includes a setup file, as well as an implementation of Question Builder.
The Visual Basic and Visual C++ sample applications use either the PivotTable or the FlexGrid control to display the results of Multidimensional Expression (MDX) queries. If the sample applications display the results of MDX queries in a Pivot Table (a Microsoft Office 2000 Web component), an MDX wrapper is used. At run-time, the sample application detects which of the following dynamic-link libraries (.dll) or ActiveX controls (.ocx) are installed on your computer.
To display the query results in a Pivot Table, the following files must be registered.
|Msowc.dll||This DLL contains the PivotTable control and is installed with Microsoft Office 2000.|
|Owcmdx.dll||This DLL contains the MDX wrapper and is installed with English Query.|
If the PivotTable control is not installed, the sample applications use the FlexGrid control version 6.0 and Microsoft ActiveX Data Objects (Multidimensional) (ADO MD) version 2.5 to display the query results.
To display the query results using the FlexGrid control, the following files must be registered:
|Msflxgrd.ocx||This file contains the FlexGrid control.|
|Msadomd.dll||This DLL is required to use ADO MD 2.5.|