Book description
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
Table of contents
- A Note Regarding Supplemental Files
- Preface
-
I. Learning ADO
- 1. Introduction to ADO
- 2. The ADO Architecture
- 3. Accessing ADO with Various Languages
- 4. The Connection Object
-
5. The Recordset Object
- Cursors: Viewing a Recordset
- Working with Recordsets
- Navigating a Recordset
- Working with Records
- Lock Types: Managing Access to a Recordset
- Summary
- 6. Fields
- 7. The Command Object
- 8. The ADO Event Model
- 9. Data Shaping
- 10. Records and Streams
- 11. Remote Data Services
- 12. The Microsoft .NET Framework and ADO.NET
- II. Reference Section
-
III. Appendixes
- A. Introduction to SQL
- B. The Properties Collection
- C. ADO Errors
-
D. The ADO Data Control
- The ADO Data Control Property Pages
- Creating Connection Strings with the ADO Data Control
- The ADO Data Control Example
-
E. Enumeration Tables
- ADCPROP_ASYNCTHREADPRIORITY_ENUM Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ADCPROP_AUTORECALC_ENUM Enumeration — (Versions 2.1, 2.5, 2.6)
- ADCPROP_UPDATECRITERIA_ENUM Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ADCPROP_UPDATERESYNC_ENUM Enumeration — (Versions 2.5, 2.6)
- AffectEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- BookmarkEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CommandTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CompareEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectModeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ConnectPromptEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CopyRecordOptionsEnum Enumeration — (Versions 2.5, 2.6)
- CursorLocationEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CursorOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- CursorTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- DataTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- EditModeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ErrorValueEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- EventReasonEnum — (Versions 2.0, 2.1, 2.5, 2.6)
- EventStatusEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ExecuteOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- FieldAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- FieldEnum Enumeration — (Versions 2.5, 2.6)
- FieldStatusEnum Enumeration — (Versions 2.5, 2.6)
- FilterGroupEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- GetRowsOptionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- IsolationLevelEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- LineSeparatorEnum Enumeration — (Versions 2.5, 2.6)
- LockTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- MarshalOptionsEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- MoveRecordOptionsEnum Enumeration — (Versions 2.5, 2.6)
- ObjectStateEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ParameterAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- ParameterDirectionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PersistFormatEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PositionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- PropertyAttributesEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- RecordCreateOptionsEnum Enumeration — (Versions 2.5, 2.6)
- RecordOpenOptionsEnum Enumeration — (Versions 2.5, 2.6)
- RecordStatusEnum Enumeration — (Versions 2.0, 2.1, 2.6, 2.6)
- RecordTypeEnum Enumeration — (Versions 2.5, 2.6)
- ResyncEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SaveOptionsEnum Enumeration — (Versions 2.1, 2.5, 2.6)
- SchemaEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SearchDirectionEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- SeekEnum Enumeration — (Versions 2.1, 2.5, 2.6)
- StreamOpenOptionsEnum Enumeration — (Versions 2.5, 2.6)
- StreamReadEnum Enumeration — (Versions 2.5, 2.6)
- StreamTypeEnum Enumeration — (Versions 2.5, 2.6)
- StreamWriteEnum Enumeration — (Versions 2.5, 2.6)
- StringFormatEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- XactAttributeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)
- Index
- Colophon
- Copyright
Product information
- Title: ADO: ActiveX Data Objects
- Author(s):
- Release date: June 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781565924154
You might also like
book
Building Microservices, 2nd Edition
Distributed systems have become more fine-grained as organizations shift from code-heavy monolithic applications to smaller, self-contained …
book
Python for Programmers, First Edition
The professional programmer's Deitel® guide to Python® with introductory artificial intelligence case studies Written for programmers …
book
Learning Python, 5th Edition
Get a comprehensive, in-depth introduction to the core Python language with this hands-on book. Based on …
book
VB & VBA in a Nutshell: The Language
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts …