Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Sample Applications and Client Interfaces

SQL Server 2000

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:

  • \Pubs

    Contains a sample English Query model for the Microsoft® SQL Server™ pubs sample database.

  • \Northwind

    Contains a model for the Northwind sample database, distributed with SQL Server version 7.0 and SQL Server 2000.

  • \FoodMart

    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:

  • \ASP

    Contains a complete Active Server Pages (ASP) sample application for English Query. It requires Microsoft Internet Information Server version 3.0 or later.

  • \VB

    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.

  • \VC

    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.

File Description
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:

File Description
Msflxgrd.ocx This file contains the FlexGrid control.
Msadomd.dll This DLL is required to use ADO MD 2.5.

See Also

Compiling an English Query Application

Deploying an English Query Application

Redistributing the English Query Run-time DLLs

Run-Time Environment for English Query Applications_

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.