Sams Teach Yourself Database Programming with Visual C++ 6 in 21 Days with CD-ROM

Lyn Robison, Lyn Robinson9780672313509, 0672313502

In only 21 days, you’ll have all the skills you need to get up and running efficiently. With this complete tutorial, you’ll master the basics of database programming and then move on to the more advanced features and concepts. Understand the fundamentals of database programming in Visual C++. Master all the new and advanced database features that Visual C++6 offers. Learn how to effectively use the latest tools and features of Visual C++ for database programming by following practical, real-world examples. Get expert tips from a leading authority for programming your databases with Visual C++ 6 in the corporate environment.

---

Table of contents :
Sams Teach Yourself Database Programming with Visual C++ 6 in 21 Days……Page 0
Table of Contents……Page 1
Introduction……Page 3
Week 1 – At a Glance……Page 6
Day 1 – Choosing the Right Database Technology……Page 7
Day 2 – Tools for Database Development in Visual C++ Developer Studio……Page 23
Day 3 – Retrieving Data Through Structured Query Language (SQL)……Page 33
Day 4 – Retrieving SQL Data Through a C++ API……Page 44
Day 5 – Adding, Modifying, and Deleting Data……Page 58
Day 6 – Harnessing the Power of Relational Database Servers……Page 68
Day 7 – Database Design……Page 80
Week 1 – In Review……Page 93
Week 2 – At a Glance……Page 95
Day 8 – Utilizing the Capabilities of Database Servers……Page 96
Day 9 – Understanding COM……Page 111
Day 10 – Database Client Technologies and the Secrets of ADO……Page 136
Day 11 – Multitier Architectures……Page 155
Day 12 – Using Microsoft Transaction Server to Build Scalable Applications……Page 172
Day 13 – Melding Object-Oriented Programming with Relational Databases……Page 187
Day 14 – Legacy Database APIs……Page 200
Week 2 – In Review……Page 215
Week 3 – At a Glance……Page 217
Day 15 – The ODBC API and the MFC ODBC Classes……Page 218
Day 16 – The Ultimate Database API: OLE DB……Page 233
Day 17 – Accessing a Data Source with OLE DB……Page 244
Day 18 – Querying a Data Source with OLE DB……Page 269
Day 19 – Navigating the Result of a Query……Page 297
Day 20 – Properties, Transactions, and Indexes……Page 320
Day 21 – OLE DB Error Handling……Page 346
Week 3 – In Review……Page 361
Appendix A – What’s on the CD?……Page 363
Appendix B – Additional Resources……Page 365
Appendix C – Installing the Microsoft Data Access Components……Page 366
Appendix D – Interpreting HRESULTS……Page 367
Appendix E – Using ADO via the OLE DB SDK……Page 369
Appendix F – Answers……Page 373
Copyright……Page 390