Ado

by Roff, Jason T.

• ISBN13: 9781565924154
• ISBN10: 1565924150
• Format: Paperback
• Copyright: 2001-06-01
• Publisher: Oreilly & Associates Inc

Summary

ADO (ActiveX Data Objects) is Microsoft's universal, language independent solution for applications to easily access data in multiple formats located on different platforms. ADO: ActiveX Data Objects provides essential information on ADO through Version 2.6, including practical code examples along the way. This book is an indispensable guide and comprehensive reference to ADO objects, collections, methods and properties for developers who want to get up to speed and master ADO.

Author Biography

Jason T. Roff is the author of three database-development books, including ADO: ActiveX Data Objects. He specializes in Visual Basic, ASP, and SQL Server development and architecture and has experience working with C++ and Assembly on everything ranging from a Commodore to a Unix box.

Table of Contents

Preface	ix
I. Learning ADO	1	(280)
Introduction to ADO	3	(16)
ADO in Context: Universal Data Access	3	(10)
ADO and COM: Language Independence	13	(2)
When to Use ADO	15	(3)
Summary	18	(1)
The ADO Architecture	19	(12)
An Overview of the ADO Architecture	19	(2)
ADO Components	21	(8)
Summary	29	(2)
Accessing ADO with Various Languages	31	(20)
Accessing ADO with Visual Basic	31	(5)
Accessing ADO with Visual C++	36	(4)
Accessing ADO with Visual J++	40	(3)
Accessing ADO with VBScript	43	(4)
Accessing ADO with JScript	47	(3)
Summary	50	(1)
The Connection Object	51	(41)
Opening and Closing a Connection: Implict Versus Explict	51	(3)
Configuring Connections	54	(16)
Choosing a Data Provider	70	(3)
Executing Commands	73	(4)
Managing Multiple Transactions	77	(8)
Determining the Layout of Your Data Source	85	(6)
Summary	91	(1)
The Recordset Object	92	(51)
Cursors: Viewing a Recordset	92	(9)
Working with Recordsets	101	(14)
Navigating a Recordset	115	(13)
Working with Records	128	(7)
Lock Types: Managing Access to a Recordset	135	(6)
Summary	141	(2)
Fields	143	(15)
The Fields Collection Object	143	(2)
Field Specifics	145	(10)
Determining Field Object Functionality	155	(2)
Summary	157	(1)
The Command Object	158	(25)
Specifying Commands	158	(5)
Executing Commands	163	(4)
Parameters	167	(5)
The Parameters Project	172	(5)
Asynchronous Execution	177	(5)
Summary	182	(1)
The ADO Event Model	183	(33)
Introduction to Events	183	(2)
The ConnectionEvent Family	185	(14)
The RecordsetEvent Family	199	(13)
Canceling Operations	212	(1)
Turning Events Off	213	(1)
Summary	214	(2)
Data Shaping	216	(20)
An Introduction to Data Shaping	216	(1)
The Microsoft Data Shaping Service	217	(1)
Shaping Commands	218	(9)
Example: Accessing Shaped Recordsets	227	(8)
Summary	235	(1)
Records and Streams	236	(25)
The Record Object	236	(16)
The Stream Object	252	(7)
Summary	259	(2)
Remote Data Services	261	(14)
RDS Object Model	261	(11)
An Example in RDS	272	(2)
More Information About RDS	274	(1)
Summary	274	(1)
The Microsoft .NET Framework and ADO.NET	275	(6)
The Microsoft .NET Framework	275	(2)
ADO.NET	277	(1)
ADO.NET Features	278	(2)
Summary	280	(1)
II. Reference Section	281	(178)
ADO API Reference	283	(176)
Finding the Reference Page	283	(5)
Using the Reference Pages	288	(171)
III. Appendixes	459	(126)
A. Introduction to SQL	461	(20)
B. The Properties Collection	481	(19)
C. ADO Errors	500	(16)
D. The ADO Data Control	516	(20)
E. Enumeration Tables	536	(49)
Index	585