ADO 2.1 Programmer's Reference [Paperback]

David Sussman (Author)

Book Description

Series: Programmer's Reference | Publication Date: June 1999

ADO (ActiveX Data Objects) is the core technology for accessing all kinds of data including relational databases, mail servers, text and other document files, and data in other non-standard formats. It is supplied with many development environments, including Microsoft's Visual C++, Visual Basic and Visual J++, and as part of the Windows NT operating system; and is also available for free from http://www.microsoft.com. It is also commonly used by ASP developers, but is supported by all COM-compliant languages. This book is a guide and reference to using ADO for your data access. We explain the structure of the ADO 2.1 object model. We cover usage of the entire object model, with extra information and examples that focus on the most commonly-used aspects of the objects. The book also contains chapters on remote access using RDS, new technologies ADOX (ADO Extensions for DDL and Security), ADOMD (ADO Multi-Dimensional) and JRO (Jet Replication Objects), and a guide to performance issues.

Editorial Reviews

Amazon.com Review

For anyone who works with databases on the Microsoft platform, ADO 2.1 Programmer's Reference provides a thorough guide to the latest Microsoft APIs in a small handbook that fits into any size briefcase. This book will be appreciated for its efficient packaging of late-breaking technical information, as well as many small samples that show how to use these APIs effectively.

The best thing about this guide is its concise format explaining all major APIs used for database programming on the Microsoft platform. There's excellent coverage of Active Data Object (ADO) basics (with whole chapters that look at its Connection, Command, and Recordset objects). The book also pays attention to programming on the client with RDS programming for Internet Explorer. Standout sections include an excellent explanation of data-shaping principles, along with a worthwhile programming how-to. Samples are presented using Visual Basic, with tips on using these objects in C++, Visual J++, and today's scripting languages.

Tutorial sections show off how to work with these APIs, and reference sections list every method and constant for quick lookup. With its handy size and thorough scope, ADO 2.1 Programmer's Reference is suitable for Visual Basic, Web scripting, Java, and C++ programmers--in other words, any developer who works with databases using Microsoft tools. --Richard Dragan

Topics covered: ADO object model and APIs, OLE DB, ADOX (for programming with tables, fields, indexes, etc.), RDS, data warehousing and ADO Multidimensional (ADOMD), Jet and Replication Options (JRO), data shaping and Internet publishing, performance, tutorial, and API reference.

From the Publisher

Who is this Book for?

• Existing database application programmers moving to ADO.
• Developers using ADO who want a convenient and comprehensive quick reference and need information about the 2.1 upgrade.

See all Editorial Reviews

Product Details

• Paperback: 640 pages
• Publisher: Wrox Press; 2nd edition (June 1999)
• Language: English
• ISBN-10: 1861002688
• ISBN-13: 978-1861002686
• Product Dimensions: 8.8 x 6 x 1.6 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #4,116,809 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 15 people found the following review helpful:

2.0 out of 5 stars Not up to Wrox standards, November 1, 1999

By 

John Pittaway (Tustin, CA USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: ADO 2.1 Programmer's Reference (Paperback)

If you have Wrox's "ADO 2.0 Programmer's Reference" and it's sample code from the Wrox WEB site, save you're money. Download "Migrating from DAO to ADO" from Microsoft's MSDN.

The ADOX samples are too shallow.

7 of 7 people found the following review helpful:

5.0 out of 5 stars The best quick reference for ADO programmers I have found!, August 31, 1999

By A Customer

This review is from: ADO 2.1 Programmer's Reference (Paperback)

Its a very easy to follow book with ADO source for most visual studio products. I used it for enterprise VB6 development and found everything I needed to know. It has a very good reference in the back for ADO constant names and values, came in really handly when coding an ADO error handling class.

5 of 5 people found the following review helpful:

4.0 out of 5 stars Thorough documentation for all applications using ADO, November 4, 1999

By A Customer

This review is from: ADO 2.1 Programmer's Reference (Paperback)

I am a VB and ASP programmer and often find myself searching for the differences in the syntax and features between the two applications. This book provides complete syntax and feature documentation for all applications; VB, ASP, C++, etc. I will definitely be looking for the updated version as soon as its available.