- Release Date: 22 December, 1998
- Used Price: $6.31
- Availability: Usually ships within 24 hours
- Third Party Used Price: $19.40
Authors: Roger Jennings, Matthew HarrisRoger 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
Customer Rating: 3.6 of 5 (15 total reviews)
- Excellent in-depth real-world exploration of VB6 DB Coding
This book is big and expensive, but well worth the cost and reading effort. It covers literally everything relating to VB6 database development and is well grounded in the traditions, methods and techniques of Visual Basic database development for business generally. ADO is effectively covered and the book demonstrates impressive Front-end design techniques for both "heads-down" data entry and decision-support, online-analytical-processing. Querie and client-server database design issues are explored with an in-depth nontrivial seriousness. MTS, multidimensional data analysis and much more is also well covered. I can't recommend this book highly enough. It is a difficult but immensely rewarding work. Thank-you Roger Jennings!
- Slow Starter
Overall, a good book. However, Jennings needs to reorganize this thing. While reading the first two chapters, I thought I had wasted my money. The book begins to pick up at the end of chapter two, up to then, it read like a reference chart. He does include plenty of code examples without delving too deep into the obscure of ADO. For VB6 database programming there is not much to choose from. This book defenitly suited my needs.
- Everything just went over my head
I had high hopes for this book from its title. I thought, Whao! at last a book that will teach me about database programming like a developer. My joy evaporated faster than you can spell VB.
The book reads like a discussion between the writers and his/her knowledgeable peers with no room for us wannabee developers. I have reasonable proramming background including VB, but this book was all greek to me. Scattered code snippets here and there with no "real" explanations, buzz words like MTS,CORBA, NED ED or whatever without their functions or scope in reference of this book are just tip of this iceberg of problems.
I will keep this book. Someday when I learn to program serious vb database, I will come back to this book and check how many chapters I really understand. I am just sad that this book and my money did little to help me towards that goal.