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. 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 Discover how to select the correct database technology to use with Visual C++; learn to use the database development tools in Visual C++ 6; explore effective database design techniques; develop client/server applications using SQL, ODBC, ADO, and OLE DB; harness the power of database servers; meld object-oriented programming (OOP) with relational databases; and build scalable database applications using Microsoft Transaction Server (MTS). This text focuses on teaching reders how to add "universal data access" to their applications. With its help, readers should be able to create Visual C++ applications that can tap into data residing in databases such as Access, SQL Server, and Oracle, as well as Excel, Word, and Windows. Organized in a day-to-day format, this handy tool teaches readers to take full advantage of database programming using Visual C++ 6 and how to add'universal data access'to their applications. The complete source and the sample databases are included on the CD-ROM. Shows readers how to use Visual C++++ 6 to improve their database programming, how to add "universal data access" to their applications, and how to use the design tools of SQL Server and component technologies such as ADO. Original. (Intermediate).
