Roger Jennings' Database Developer's Guide With Visual Basic 6 - Softcover

Jennings, Roger

Softcover

ISBN 10: 0672310635 ISBN 13: 9780672310638

Publisher: Sams, 1999

Synopsis

Roger Jennings' Database Developer's Guide with Visual Basic 6, Third Edition, provides in-depth coverage of all new database-related features of Visual Basic 6.0. Topics includes OLE DB 1.0, Active Data Objects (ADO) 2.0, Remote Data Services (RDS) 2.0, and DataEnvironment and DataReport objects. Client/server chapters describe how to create high-performance decision-support and OLTP applications with SQL Server 6.5 and 7.0. Advanced topics include executing parameterized stored procedures with ADO Command objects, designing and deploying Microsoft Transaction Server 2.0 components, and writing Multidimensional Expressions (MDX) to extract summarized data from PivotTable and SQL Server OLAP Services (formerly Plato) DataCubes with ADOMD, ADO 2.0's implementation of MDX.

About this title

Review

Roger Jennings's Database Developer's Guide with Visual Basic 6 offers a full tour of programming ActiveX Data Objects (ADO) with Visual Basic 6 for building today's corporate applications.

The first part of the book does an excellent job of relating older Microsoft database APIs, such as open database connectivity (ODBC), Remote Data Objects (RDO), and Data Access Objects (DAO), to the new ADO and object linking and embedding database OLE-DB standards. The author reviews database basics (including normalized tables) and provides a solid introduction to SQL (including joins and grouping).

Generally, this book highlights the built-in tools and capabilities of Visual Basic 6, such as bound controls, charts, graphs, and reporting features. To illustrate ADO, the author provides a sample application that works with Microsoft's WebTV database (with over 5,000 lines of sample code on the accompanying CD-ROM).

Next come the basics of corporate networking and then running Access in a networked environment. Coverage of SQL Server 6.5/7.0 follows, including transactions. The author's how-to guide to moving client-side SQL code to stored procedures on database servers is a standout here.

Later sections look at Visual Basic 6 Internet programming, including its support for ActiveX Documents, WebClasses, and the Remote Data Service (RDS) in Internet Explorer. (Overall, though, this is a book written for serious intranet corporate development rather than the public Internet.) Final chapters look at middle-tier transaction management in Microsoft Transaction Server (MTS) and even the basics of data warehousing.

Best for its explanation of new Microsoft database technologies and how to bring older code up to speed, this book can serve as a valuable choice for any serious corporate Visual Basic database programmer. --Richard Dragan

About the Author

Roger Jennings is a principal of OakLeaf Systems—an Oakland, California consulting firm that specializes in the design and implementation of client/server database systems for Fortune 500 companies. He brings over 25 years of computer programming experience to his best-selling Sams titles, including Database Developer¿s Guide with Visual Basic 3, Database Developer¿s Guide with Visual Basic 4, Access 1.1 Developer¿s Guide, Access 2 Developer¿s Guide, and the Roger Jennings¿ Database Workshop books, for which he is the series editor. In addition to writing books, Roger is a Contributing Editor and the writer of “Database Design” columns and feature articles on Visual Basic, Access, and client/server computing for Fawcette Technical Publications¿ Visual Basic Programmer¿s Journal.

Edition details

• Publisher: Sams
• Publication date: 1999
• ISBN 10: 0672310635
• ISBN 13: 9780672310638
• Binding: Paperback
• Language: English
• Number of pages: 1172