SAMPLE: Mfceqado.exe Shows How to Use English Query with MFC and ADO

Mfceqado.exe is an English Query ADO Visual C++ sample that uses ADO in a Visual C++ MFC application to query SQL Server statements generated by the English Query engine. The sample uses DataGrid Control version 6.0 (OLEDB) to display the results.

The following files are available for download from the Microsoft Download Center:
Download the MfcEqAdo.exe package now. (http://download.microsoft.com/download/vc60pro/utility/1.0/w9x/en-us/mfceqado.exe) For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Description of Important Files

Dbinter.cpp: English Query module to execute and display SQL languge.

HistoryDlg.cpp: English Query file that implements History and Suggested Questions dialog box.

ListClarifyDlg.cpp: English Query file that implements List Clarification dialog box.

Mfcequi.cpp: A front-end UI for English query.

MfcequiDlg.cpp: Main dialog box for a front-end UI for English Query.

Nlinter.cpp: Interface to English Query Engine Object Model.

ListClarifyDlg.cpp: Implements Query Window dialog box.

ShowSQLDlg.cpp: Implements Show SQL dialog box.

The English Query code used in this sample is very similar to the MFCUI C++ Remote Data Objects (RDO) English Query sample that ships with the SQL Server 7.0 CD-ROM.

Refer to the following Microsoft Knowledge Base article for more information on how to use DataGrid Control with ADO in Visual C++:

Steps to Run Sample

1. Build and run Mfcequi.exe.
2. Specify an English Query (EQ) application (.eqc) file and a question (.eqq) file in the Welcome dialog box. You can use either the Pubs.eqc or NorthWind.eqc sample EQ files that are installed by EQ in the samples folder.
3. Click Start Application in the Welcome dialog box.
4. Choose a SQL Server 7.0 data source in the ODBC Administrator dialog box that displays when you click Start Application.
5. Enter an English sentence to query into the main query dialog box. For example, enter the following query for the pubs database if you select Pubs.eqc in step 2:
   
   How many authors live in Oakland ?
6. Click Submit to run the query. The English Query parses the English statment to generate SQL language. The application uses ADO to submit the SQL statement to SQL Server. The DataGrid displays the results. Click Show SQL to see SQL language command sent to SQL Server.

For additional information on the EQ Object Model used in the sample, please search the English Query Help Online with the words "Object Model".

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site: For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site: