Getting data across platforms and formats is a cornerstone of present-day applications development. ADO: ActiveX Data Objects is both an introduction and a complete reference to ADO (ActiveX Data Objects), Microsoft's universal data access solution. You'll learn how to easily access data in multiple formats--such as email messages, Access databases, Word documents, and SQL databases--even on different platforms, without spending extra time learning every last detail about each format.
Author Jason Roff shows by example how to use ADO with your programming language of choice to save programming time, so you can concentrate on the content and quality of your application rather than the nitty-gritty of specific data formats.
ADO: ActiveX Data Objects includes:
Chapters dedicated to the Connection, Recordset, Field, and Command objects and the Properties collection
A complete, detailed reference listing every ADO object, method, property, and event, in convenient alphabetical order
Chapters on ADO architecture, data shaping, the ADO Event Model
An appendix containing enumeration tables used by ADO objects and collections, listed alphabetically
Brief introductions to RDS, ADO.NET, and SQL
ADO: ActiveX Data Objects is a versatile one-stop guide to both the theory and practice of programming with ADO through Version 2.6. The thorough reference section and topic-specific chapters will help you find quick answers about the details of objects, collections, methods, and properties of ADO. And the abundance of practical code examples will give you a good grasp of how to use ADO's strong points most effectively.
Chapter 1 Introduction to ADO
ADO in Context: Universal Data Access
ADO and COM: Language Independence
When to Use ADO
Chapter 2 The ADO Architecture
An Overview of the ADO Architecture
Chapter 3 Accessing ADO with Various Languages
Accessing ADO with Visual Basic
Accessing ADO with Visual C++
Accessing ADO with Visual J++
Accessing ADO with VBScript
Accessing ADO with JScript
Chapter 4 The Connection Object
Opening and Closing a Connection: Implicit Versus Explicit
Choosing a Data Provider
Managing Multiple Transactions
Determining the Layout of Your Data Source
Chapter 5 The Recordset Object
Cursors: Viewing a Recordset
Working with Recordsets
Navigating a Recordset
Working with Records
Lock Types: Managing Access to a Recordset
Chapter 6 Fields
The Fields Collection Object
Determining Field Object Functionality
Chapter 7 The Command Object
The Parameters Project
Chapter 8 The ADO Event Model
Introduction to Events
The ConnectionEvent Family
The RecordsetEvent Family
Turning Events Off
Chapter 9 Data Shaping
An Introduction to Data Shaping
The Microsoft Data Shaping Service
Example: Accessing Shaped Recordsets
Chapter 10 Records and Streams
The Record Object
The Stream Object
Chapter 11 Remote Data Services
RDS Object Model
An Example in RDS
More Information About RDS
Chapter 12 The Microsoft .NET Framework and ADO.NET
The Microsoft .NET Framework
Chapter 13 ADO API Reference
Finding the Reference Page
Using the Reference Pages
Appendix Introduction to SQL
Appendix The Properties Collection
The Property Example
Appendix ADO Errors
Working with Errors in ADO
The Errors Example
Appendix The ADO Data Control
The ADO Data Control Property Pages
Creating Connection Strings with the ADO Data Control
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The bird on the cover of ADO: ActiveX Data Objects is an ivory-billed woodpecker (Campephilus principalis). Considered extinct by many naturalists and ornithologists (the last confirmed sighting was in the 1950s), the "ivory-bill" was never abundant in its habitat, the southeastern United States and Cuba. With glossy black plumage, white markings, and a red tufted crest (males only), the ivory-bill looks extremely similar to the pileated woodpecker, with whom it also shared its habitat. The similarities between the two birds has been the cause of much trouble, as eager amateurs add to unconfirmed sighting reports of the ivory-bill when they have probably spotted the pileated woodpecker. This is especially troublesome for naturalists who hold out hope that the ivory-bill may still exist in the far reaches of Louisiana forests or in Cuba. In the early 1990s, many nature and birding groups spent considerable amounts of money mounting search efforts for the ivory-bill.
As do all woodpeckers, the ivory-bill has a chisel-like bill and a long, hard-tipped, sticky tongue; the first for drilling and scaling bark, the latter for retrieving beetles and grubs on which to feed. Retrieving food in this manner, however, is not what creates the drumming sound that many associate with woodpeckers. Rather, woodpeckers drum when reinforcing their claim to a territory, creating the loudest drum possible by striking the tops of dead, hollow trees.
Important differences between the closely linked ivory-billed and pileated woodpeckers include their bills (the ivory-bill's was, well, ivory, while the pileated woodpecker's bill is gray), their sizes (the ivory-bill was the largest of all North American woodpeckers), and their calls (the ivory-bill's was a "toot"; the pileated's is a "kuk"). In 1987, Dr. Jerome A. Jackson of Florida Gulf University caught the ivory-bill's distinctive call on eighteen minutes of tape in Louisiana, adding to the excitement created by various unconfirmed sightings. The most recent and credible sighting occurred in 1999, when graduate student David Kulivan sighted a pair of what were supposedly ivory-bills in southeastern Louisiana.
While The Nature Conservancy declared the ivory-bill extinct in 1994, the U.S. Fish and Wildlife Service has not yet added it to its extinction list. The reason for its near or possible extinction: logging of the old-growth forests in which it lived. Jeffrey Holcomb and Sarah Jane Shangraw were the production editors for ADO: ActiveX Data Objects. Jeffrey Holcomb copyedited the text. Linley Dolby, Matt Hutchinson, and Claire Cloutier provided quality control. Pamela Murray, Sarah Jane Shangraw, and Joe Wizda wrote the index. Sarah Jane Shangraw did page composition.
Hanna Dyer designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Erica Corwell produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.
Melanie Wang designed the interior layout based on a series design by Nancy Priest. Anne-Marie Vaduva converted the files from Microsoft Word to FrameMaker 5.5.6 using tools created by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book; the code font is Constant Willison. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. This colophon was written by Jeffrey Holcomb.
Comments about O'Reilly Media ADO: ActiveX Data Objects:
Understandable. Good example code.
One negative: presumes knowledge of, or access to "biblio.mdb" database. If you're not familiar with it, examples with references to it are less meaningful. You should include an appendix with a few records so the uninformed can see how it's structured.
Comments about O'Reilly Media ADO: ActiveX Data Objects:
The book contained many examples of sample code. For myself, who is not an expert in the subject, this was valuable.
I also liked that it was written in a tone that while instructive for both novice and expert, didn't "talk down" to someone who isn't up to speed on all the concepts. This is important to me in that I must interface with those experts and by using this book, I was able to ask intelligent questions and avoid asking the "dumb questions".
It was well organized and finding specific information was quite easy. Good work.