Customer Reviews

Visual Basic Oracle 8 Programmer's Reference

5 star:		(11)
4 star:		(4)
3 star:		(4)
2 star:		(0)
1 star:		(2)

 

 

This book will sharpen your VB skill especially when it deals with OOP, but you really want to get it for the wealth of information about Oracle.

We got a few copies of the book and distributed them among our programmers. Various members of the team had different skill that needed to be sharpened. Some needed a refresher course in SQL, others who came from legacy systems and learned only the basics of VB got a bit about OOP, all needed to learn about stored procedures and PL/SQL. This simple and short book gave us all of that and much more.

We have opted to use ADO as our conduit to the database. The book gives us a complete reference to ADO and 3 chapters guided us in its use with Oracle. It starts with simple Recordsets and moves all the way to writing robust code using stored procedures and ADO.

We've used the code in the book as a staring point to our project.

If you have limited shelf space and need just one book, this is the book to have

I found it to be an Excellent Learning tool for SQL and Oracle. The chapters dealing with SQL and PL/SQL are real gems. The applications are simple enough yet encompassing enough to serve as real-life example of how to code VB, SQL, and PL/SQL for a successful project.

There are only two books that guide the programmer through the maze of using Oracle in VB. After evaluating both, We've offered "VB Oracle 8 Programmers guide" to our programmers as a lead to a recent project. We've developed the project completely based on the guidelines in the book. This is a complete guide to everything we needed to know and we used the code samples as the basis for our successful project. Another advantage, our programmers learned SQL, PL/SQL and advanced their level of Object Oriented Programming in VB.

Just adding my voice to the yay's on this book. Nick Snowden's Oracle VB book doesn't hold a candle to it, and reviews have said the other Oracle VB is heavy in OO40.

This book does cover OO40 and also ADO. It is written in a tutorial form, which can make it a bit more difficult to get into at first, but if you take the time (I hankered down and gave it a day and a half) it is well worth it. Straightforward, workable examples, with downloadable code, demonstrate building an unbound form, using a data class, and implementing stored procedures that take parameters and return resultsets. It finally goes into middle-tier COM objects, which I passed on.

The book sticks to the point with its information about PL/SQL and data access. You have exactly what you need, demonstrated in examples that you can easily alter to suit your needs. There are also referce sections on ADO and OO40 that explain the objects, with code samples and suggestions specifically related to Oracle. (For example, the connection section explains that the only cursor location appropriate to Oracle is adUseClient, perhaps obvious, but nevertheless an inconsistant error that we had made earlier.)

There are only two things I would have liked to see added to this book. Though the book uses the OO technique of data classes, it doesn't go far enough into describing the reasons for doing so, which is said will be in another book. Although this is a heavy topic, it would have been nice to at least get a few pages on this, since the choice of a data class typically involves a bit more complexity and more code. And finally, it makes the error of assuming that you will cover the OO40 chapters and then do the ADO. However, you can overcome this by skimming the OO40 chapters for the descriptions that are not repeated in the ADO sections.

The book accomplishes what it sets out to do. It is not a comprehensive manual for either ADO (/OO40) or PL/SQL. It is a clear, how-to on the practical marriage of the two. Buy it, buy it, buy it, beg, or borrow it.

An excellent detailed book. Clearly demostrates the power of VB and Oracle (working together) with real world examples. A first of it's kind.

- LD

This book seems to have been based on version 2.2 of OO4O. It doesn't cover the features added to version 2.3 (like connection pooling) or all of the new features added to the 8.1.5 release such as LOB support, Object/Ref/Collection support or AQ. It also doesn't cover the important strategies for getting awesome performance under IIS (such as using the built in connection pooling or being careful of what dynaset options you choose). As far as OO4O goes, you are probably better off just reading the online help.

This book is a easy introduction to practically all basic concepts and technologies involved in Visual Basic programming for Oracle 8 back end. Among many other things it covers ADO, OO4O, PL/SQL. Contains many useful tables. It could be very useful as a startup manual for Visual Basic programmers who are new to the Oracle world. However, if you are experienced in Oracle, VB and PL/SQL, look elsewhere. Even for inexperienced programmers this book could become worthless after a week. For thorough Oracle presentation I would recommend the following books: ISBN: 007212606X ISBN: 1565923359

Great book! I'm new to Oracle but have 2 years w/VB. Mr. Trietsch is great. He approaches the basics but works quickly into a few advanced issues. He also lets you know what he does & doesn't cover.

This is a good book for the developer who doesn't have time to muttle through all of the personal stories and background information before getting to the useful information.

Tons of info in a very short book with an easy to read style. The book has an in depth tutorial of SQL in one short chapter and another such short comprehensive tutorial of PL/SQL. These alone are worth the price. An in depth discussion of 0040 and ADO with full working programs instead of the standard code snippets. The final project that is simple yet involves depth of data, is done in 4 different ways to illustrate a more complex example of all that has been learned before. You can get to any information you need via the index and the full references of ADO and oo40.

Bravo!

This book was a great deal at 5 dollars. IT is older though. I wish that the author would write a book that included the newer functions that are available in VB.NET for Oracle. So that's why only 4 stars.