Review

1. How can you connect an ADO application to an ODBC data source?
2. What is wrong with the following SQL statement?

 SELECT * FROM authors WHERE au_lname LIKE M% 

3. You need to open a CRecordset object so that you can list all the records in a database table to the printer. What value should you supply to the first parameter of the Open() function?
4. What does the CRecordset::GetDefaultConnect() function specify?
5. With which ADO object is the Errors collection associated? What does it contain?
6. Which property of the ADO Data Control is used to specify an SQL command to retrieve records from the data source?

Answers