» » Professional Visual Basic 6 Databases

Download Professional Visual Basic 6 Databases epub

by Charles Williams

Visual Basic is the #1 programming tool in the world and 70% of VB applications involve a database. However, there is little advanced information for VB database programmers that has been proven in the real world.

This book has broad coverage of many issues relating to advanced database design and implementation using VB6. The main feature is the demonstration of the 3 tier solution, enabling more scalable applications.

From the coverage of 2 tier solutions a thorough grounding of SQL Server 7, ADO and Database design is provided. The graduation to 3 tier applications is achieved through a practical demonstration of the techniques learned.

Download Professional Visual Basic 6 Databases epub
ISBN: 1861002025
ISBN13: 978-1861002020
Category: Technology
Subcategory: Programming Languages
Author: Charles Williams
Language: English
Publisher: Apress; illustrated edition edition (July 1999)
Pages: 883 pages
ePUB size: 1343 kb
FB2 size: 1806 kb
Rating: 4.1
Votes: 608
Other Formats: azw rtf txt docx

I wrote this review on 06/19/2000. Now I'm an official .Net programmer. To those who are not "Classic VB" mavens, but have to write code in it, this is one of two books that are a must. The second is Balena's "Programming Visual Basic 6.0" by MS-Press. If it's done in VB, Balena shows you how and why. Plus it has the book on the CD. This book + Belan's = success in VB 6.0.
(Original Comments:)
I've been a programmer long enough to know that no one book could "have it all." First the plusses. The book is well organized and very readable. The section on normalization is most understandable that I have encountered. I've done three-tier applications the hard way - UNIX, and I've never tackled a WEB project before. Now I am confident that I can tackle an "n-tiered" application with the Microsoft DNA without embarrassing myself. This book has armed with me the "Hello, world!"'s that are necessary to get some real work done.
The minuses are not show stoppers. Wrox doesn't have a CD so you have to download and unzip the source code. There are some typos in the samples. And, I hate to get picky on semantics, "Professional" programmers avoid data controls. Most text books use data controls, but a rookie should know that they are never acceptable in a production program. At best, we use them for "proof of concepts" and, sometimes, to build cut-and-paste code. Finally, if you're looking for help using VB 6's Data Access Tools with Oracle, this book will be of minimal value. For Oracle, the best book - the only book, as far as I know, is "Oracle Programming With Visual Basic" by Snowdon. It's VB 5 oriented, but it is useful.
I have read both this book and its series "predecessor" by John Connell, starting with Connell. While there is considerable overlap between the two, as other reviewers here have remarked, I'd choose this one if I were only to buy one book. Not that Connell is not a good book; it's just that I found this one more readable where it covered the same material. The "Professional" appellation should not frighten off beginning to intermediate readers, nor convince them that they must start with the "Beginning" title first.
After reading the introductory, "basics" chapters of this book I came away with a much better understanding of such things as connection strings, ADO objects, and basic SQL syntax than after reading the Connell book. My major gripe about many programming books--and I have been devouring them in bulk over the last two years--is that they often launch into code examples without adequately and systematically explaining the various methodologies involved.
For instance, I don't think I have ever read elsewhere a better overview of the ADO Object Model (Chapter 7)--it's well done because it's covered in an organized and systematic fashion that is appropriate for this book's target audience (the intermediate programmer who might be new to some of the technologies presented here but who is not to programming per se) rather than as a chaotic catalog of example after example--though there are plenty of those as well where appropriate.
Great content aside, another niggling gripe I have with this and other programming books, perhaps more often with Wrox (maybe it's just a sample error because I read more of them,) is the presence of annoying grammatical errors. If only someone could teach the editors (are they awake out there?) how to use semicolons, because sentences smash into each other like minivans at the supermarket with irritating regularity. The copy editors, who are supposed to fix typos, also must be asleep at the switch. We are entitled to expect better from a forty-dollar book. But just grit your teeth and focus on the content.
In short, if you already know something about SQL, database design, and VB, but need help making them all work together, I think this one is the ONE you should buy if you can only buy one.
This book really taught me a lot. The only thing I would have liked was a better explanation on how to implement a desktop database (local, not on a server). If you read between the lines you can figure it out, but it would have been better if he had outlined some specifics. The hands-on approach of this book really helps you learn. I wouldn't call this a be-all-end-all book of database programming for VB, but it's a great start and the appendices serve as a more in-depth reference.
I needed a quick reference for using ADO with VB 6 and I found the chapter that covers ADO confusing. I finally relied on sample code in TechNet...
If you are looking to get overall information about how to use databases with Visual Basic 6, go for it. If you already have experience on working with VB for n-tier applications and knows ADO pretty well, look elsewhere.
This book covers a great deal of material, thus going over some details of them. This book is good for beginners to intermediate people that wants to have quick solutions.
For the others, for example, if you are looking for a better implementation of n-tier or to pass data between components; you will have some information in this book but I would suggest the Visual Basic 6 Business Objects and VB6 Distributed Objects, both from Wrox, to get a full coverage on the subject.
Overall, this book is good for VB/Data starters.
This book is virtually worthless if you do not have SQL Server 7.0. In addition, the bulk of the first 13 chapters is covered in better detail in Wrox's Beginning VB6 Database's by John Connell. So if you have started with that book, or any other VB database book, then the first half of this book is all review.
It does get into some interesting topics, but since I did not have SQL Server 7.0 available, I could not really use this book.
If you have SQL server 7.0, VB 6.0 and are new to databases, then this book is PERFECT.