English Query Usage Issues
The following issues may affect the performance of English Query applications.
English Query OLAP Projects Are Not Supported on Windows 95 and Windows 98
- English Query is supported on the Microsoft® Windows® 95 and Windows 98 operating systems, but the server components required by Microsoft SQL Server™ 2000 Analysis Services are not.
- To build English Query OLAP projects on Windows 95 and Windows 98, manually install a SQL Server version 7.0 OLAP Services client (such as the MDX Sample or Microsoft Excel 2000). You still cannot build OLAP mixed mode projects that use multidimensional expressions (MDX) and SQL because those projects require Decision Support Objects (DSO), which do not work at all on Windows 95 and Windows 98. However, with this workaround, you can create or edit an English Query OLAP project on Windows 95 or Windows 98, though you cannot select the Enable SQL option in an OLAP project.
"Enable SQL" in OLAP Model Requires Membership in the OLAP Administrators Group
- With Analysis Services, you cannot access the underlying database structure of an OLAP cube in an English Query model unless you are a member of the OLAP Administrators group.
That is, you must be a member of the OLAP Administrators group or a Microsoft Windows NT® 4.0 and Windows 2000 user group, on the server of the Analysis Services database for which you are building an English Query model. The user of the English Query modeling tool must have OLAP Administrator permissions to load the tables underlying the cubes using DSO.
Domain Files from Earlier Versions of English Query Must Be Rebuilt
- English Query domain files (*.eqd) are built to work with a specific version of the English Query engine. If you are upgrading from an earlier version of English Query, you must rebuild your English Query domain files from your project (*.eqp) using the Model Editor.
DBCS (Unicode) Is Not Fully Supported
- Because English Query is English-only, the user interface for the authoring tool does not support double-byte character keyboard input. However, Unicode data in your database is supported.
Temp Table Generation Requires SQL Server version 6.5 SP3 or Later
- SQL Server version 6.5 is supported by this release of English Query, but only when you install Service Pack 3 (SP3) or later. If you are not running SQL Server 6.5 with SP3, you may encounter problems with generated temp tables that are required for some queries.
Problems Converting English Query 1.0 Projects to this Version of English Query
- If you encounter problems converting English Query version 1.0 to this release of English Query, convert the English Query 1.0 project to English Query version 7.0 first.
Full-Text Search Does Not Work on Tables With uniqueidentifier Keys
- English Query is unable to build SQL statements for questions that require a full-text search on a table that has a uniqueidentifier key. Asking such questions may cause English Query to stop responding.