Ado

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.

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.

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

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Summary

Author Biography

Table of Contents

Supplemental Materials