Roger Jennings' Database Developer's Guide with Visual Basic 6 [Paperback]

Roger Jennings (Author), Matthew Harris (Author)

Book Description

Publication Date: January 1, 1999 | ISBN-10: 0672310635 | ISBN-13: 978-0672310638

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.

Editorial Reviews

Amazon.com 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

From the Back Cover

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.

See all Editorial Reviews

Product Details

• Paperback: 1200 pages
• Publisher: Sams (January 1, 1999)
• Language: English
• ISBN-10: 0672310635
• ISBN-13: 978-0672310638
• Product Dimensions: 9.1 x 7.4 x 2 inches
• Shipping Weight: 3.9 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #2,876,560 in Books (See Top 100 in Books)

More About the Author

I'm the principal consultant of OakLeaf Systems, a Windows Azure MVP and the author of 30+ books on Microsoft operating systems (Windows NT and Windows 2000 Server), Windows Azure, databases (SQL Server, SQL Azure and Access), .NET data access, Web services and InfoPath 2003. The books have more than 1.25 million English copies in print and have been translated into 20+ languages.

My latest books are "Microsoft Access 2010 In Depth" (12th edition) for Que Publishing and "Cloud Computing with the Microsoft Azure Services Platform" for Wiley/Wrox.

I'm also the curator of the OakLeaf Systems (http://oakleafblog.blogspot.com) and Access In Depth (http://acccessindepth.blogspot.com) blogs, a contributing editor of 1105 Media's "Visual Studio Magazine" and a frequent contributor to their "Redmond Developer News" newsletter.

OakLeaf's Code of Federal Regulations (CFR) Web service won the charter Microsoft .NET Best award for horizontal XML Web service solutions.

Customer Reviews

Most Helpful Customer Reviews

13 of 13 people found the following review helpful:

2.0 out of 5 stars Did an intern at SAMs write this?, March 22, 2000

By 

johnb (Pennsylvania) - See all my reviews

This review is from: Roger Jennings' Database Developer's Guide with Visual Basic 6 (Paperback)

Too many typos and problems with sample code! I can't believe Roger Jennings wrote this. Simple SQL code is flawed ie: author's use of "=>" (p.256, 261) rather than ">="; references to the sample code on the CD are incorrect -EVERYTIME! - the installation puts them folders identified as \ch03, etc. but in the book (and sometimes hardcoded in the .frm files) the path is \Ddg_vb6\Chaptr##. All of the .mdb files that have linked tables must be opened and relinked! If you don't know to do this (that is, if you are a newbie which why you are reading this book) you get an error message that is cryptic at best. I haven't opened a project file and executed it without some problem. For $60 I expected more. SAMS publishing should take a lesson in customer service and visit WROX publishing. No errata is available for this book! Why? Anyone who has written a positive thing about this book must not have opened any of the sample apps on the CD. Too bad, RJ is an excellent author but his support staff needs to learn VB because most of the samples are flawed.

10 of 11 people found the following review helpful:

2.0 out of 5 stars Needs another round of editing before publishing, April 6, 2000

By 

johnb (Pennsylvania) - See all my reviews

This review is from: Roger Jennings' Database Developer's Guide with Visual Basic 6 (Paperback)

Why don't authors test their code before they print it? All throughout the book author does this. For example, client side cursors can only be static type and in chap 3 the author codes .CusorLocation=adUseClient, .CusorType=adOpenKeyset (p.143). Geez. Other samples have adOpenDynamic. You can set the cursor type property to these enums but if you check the property via debug.print or in the locals window you will see the property = static. Something that simple makes me a bit unsure what is wrong with the more complex material in the latter part of the book. Other things that bothered me were the code on CD needed to be hacked to run. They should run right out of the box. Too much emphasis on the data controls. And what was all that about VCR drivers and video picons? what a waste of time and space. If I was married to this book I'd get a divorce!

4 of 4 people found the following review helpful:

2.0 out of 5 stars Everything just went over my head, October 14, 2002

By 

Scooby Doo (Ozone Park, NY USA) - See all my reviews

This review is from: Roger Jennings' Database Developer's Guide with Visual Basic 6 (Paperback)

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.