ADO Programming for Dummies

Find out how to access data with any Office 2000 product, Active Server Pages or Visual Basic using ADO - it's easy with this book!

The information that organizations need to conduct their business is stored in a variety of data formats, from traditional relational databases such as Access and SQL Server 7, to non-traditional sources such as Excel spreadsheets, email folders and even Word text files. Now, all of this data is available to application developers through a common Microsoft programming interface, ActiveX Data Objects (ADO). ADO Programming for Dummies shows Office 2000 VBA developers, Visual Basic programmers, web developers, or anyone who writes Windows scripts how to query data sources and present the results to users in a variety of applications. Expert author Rob Krumm is author of the popular Access 2000 Programming for Dummies with years of experience as a developer of commercial database programs. The CD contains sample data sources with which to experiment as well as the source code for all programs presented in the book. A cheat sheet lists the most used properties and methods of the ADO and OLE DB object models.

Contents

• Introduction
• Chapter 1: What ADO Does for Me
• Chapter 2: OLE DB Providers
• Chapter 3: Using ADO Recordsets
• Chapter 4: ADO Database Operations
• Chapter 5: The ADO Command Object
• Chapter 6: Building Data-Enhanced User Interfaces with ADO
• Chapter 7: Client/Server Databases
• Chapter 8: ADO Services
• Chapter 9: The Internet Information Server and ADO
• Chapter 10: Data Forms on the Web
• Chapter 11: Server-Side Custom Database Objects
• Chapter 12: Client-Side Recordsets
• Chapter 13: Client-Side ADO
• Chapter 14 : ADO and OLAP
• Chapter 15: ADO Data in Office 2000
• Chapter 16: ADO Documents
• Chapter 17: Ten Useful Web Links
• Chapter 18: Ten Programming Tips
• Index