Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Buy Used
$7.23
Condition: Used: Like New
Comment: Used, but looks brand new. Only very slight signs of use. Cover and binding are undamaged, and pages are crisp and unmarked. Unbeatable customer service, and we usually ship the same or next day. Over one million satisfied customers!
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

ADO 2.6 Programmer's Reference Paperback – August, 2000

3.6 out of 5 stars 5 customer reviews

See all formats and editions Hide other formats and editions
Price
New from Used from
Paperback
"Please retry"
$2.50 $0.43

There is a newer edition of this item:


Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more

Editorial Reviews

Amazon.com Review

Useful for anyone who programs with databases on Windows, the third edition of ADO 2.6 Programmer's Reference is an up-to-the-minute source of information on the latest features that are available in ActiveX Data Objects (ADOs) and related standards from Microsoft. Besides the fact that it's a handy resource that you can use every day, this book is filled with practical tips on how to get the most out of database APIs.

The practical focus is on explaining ADO and related standards. In a chapter-by-chapter tour, the book covers all of the bases with Microsoft Universal Data Access (UDA) strategy. You learn what works best when connecting to recordsets with ADO, and when to take advantage of Internet Explorer-specific APIs like RDS, data shaping, and JRO. Each chapter examines the objects in a particular database standard, and then drills down into the properties, methods, and events that you'll need to program with ADO effectively.

Tips and even warnings about known bugs for particular objects are provided in abundance. The charts listing features that are supported by various OLE DB providers also are useful. You get specific suggestions about which APIs to use, plus some benchmarking of various cursor types and database programming strategies (comparing stored procedures, parameterized queries, and hard-coded SQL within ADO code).

Reference material naturally makes up the heart of this text. With over 250 pages on all of the important ADO standards (including RDS, ADOX, ADOMD, and JRO), all of the properties, methods, events, constants, and even error codes are listed, making this an indispensable book for any VB, VBScript/JavaScript, or C/C++ programmer.

Experienced ADO developers will appreciate the attention to new features, including the latest in support for XML and multidimensional databases. Even if you're entirely new to Microsoft databases, this patient and very thorough tour of ADO can help you get productive with database development quickly on today's Windows. --Richard Dragan

Topics covered:

  • Overview of Microsoft Universal Data Access (UDA)
  • OLE DB and ActiveX Data Objects (ADOs)
  • New ADO 2.6 features and enhancements
  • ADO tutorial
  • Asynchronous database programming with events
  • Connection pooling
  • Using the Connection object (including connection pooling, transactions, and events)
  • The Command object in detail (including Command Streams, parameterized queries, and the Parameters collection)
  • Using the Recordset object (methods, properties, events, and collections)
  • The Record and Stream objects
  • Guide to ADO collections (Errors, Fields, and Properties)
  • Remote Data Services (RDS) APIs and tutorial
  • Accessing database information with ADO extensions for DDL and security (ADOX)
  • ADO Multidimensional (ADOMD)
  • Jet and Replication objects (JRO)
  • Tutorial for RDS data shaping
  • Performance issues with ADO (cursor types compared)
  • Enhancing performance with connection pooling
  • Stored procedures and parameterized queries
  • Comprehensive reference to all of the ADO objects, methods, properties, events, and error codes

From the Publisher

This book has been selected by the editors of Wrox Press to be part of the Wroxbase website.

This book is a reference guide for the ADO programmer; it's primarily aimed at demonstrating and explaining the features of ADO 2.1 and the ways that they can be used. As such, it isn't a beginner's guide - though if you have programmed any data-access applications in the past, you'll be able to use it to get up-to-speed with ADO.

In particular, the book is aimed at application developers who already use Microsoft's data access methods in their applications, but want to take full advantage of the new features of ADO 2.5 and 2.6. It includes all the information required for any reasonably experienced developer to start using ADO within their Web pages and distributed applications. Finally, it is ideal for existing ADO users, to bring them quickly up-to-date with version 2.6.

NO_CONTENT_IN_FEATURE


Product Details

  • Series: Programmer to programmer
  • Paperback: 689 pages
  • Publisher: Peer Information; 3rd edition (August 2000)
  • Language: English
  • ISBN-10: 186100463X
  • ISBN-13: 978-1861004635
  • Product Dimensions: 9 x 6.1 x 1.6 inches
  • Shipping Weight: 2.2 pounds
  • Average Customer Review: 3.6 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #4,084,512 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Top Customer Reviews

Format: Paperback
This is an excellent update to the original ADO 2.0 & ADO 2.1 programmer's reference. It covers all of the new features in a very readable and easy to use format. There are lots of code snippets and example to help you understand quickly.

The ADO objects are all covered in detail, along with ADOX, ADOMD, Remote Data Services, Jet replication, Data Shaping, even XML stuff. Plus there is an interesting chapter on Performance issues which gives you a hand in deciding what sort of techniques to use to speed things up. There are also around 15 appendices which have just the method names, constants and quick summaries so you can look them up fast. There are even charts showing which drivers support which OLE DB properties and which providers support which schemas.

Very highly recommended. First-rate reference book, excellent price. If you already program with ADO you cannot go wrong with this.
Comment 26 of 27 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I was looking for pure reference. This is it. It will tell you essentially everything you need to know about ADO. I used it on NT with ADO 2.1 on MS Access 97 database. This helped tremendously.
Remember those old Borland books where they tell you which C functions work on which operating systems? This book takes the same approach. Even though it says ADO 2.6, it distinguishes what works on NT, vs Win2000. Also helps you with database differences, Oracle vs SQL Server vs MSAccess.
You'll wear out the binding like I did, I guarantee it. Happy programming!
Comment 8 of 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Once again, I am awed by the fact that a publisher can continually put out books with untested code samples. I am an advanced database programmer and I found this book of little use to me. RDS was simply glazed over with the properties, events and methods supplied, but no concrete explanations of how to use it in an Internet environment. For a beginner or intermediate user, this book may supply a good foundation, but when trying to figure out why the code samples don't work or why there are inconsistencies in the syntax of the samples, this book will leave you hanging. May as well just fight it out with MSDN...
Comment 13 of 16 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I agree that this is an excellent reference source for ADO, but I was dismayed to find a number of typos that kept me searching other sources for proper syntax (e.g. the example on page 20 has a space between OLE and DB in a line of code, which will return an error.) Hopefully these will be fixed in subsequent printings.
Comment 7 of 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By Amadeus on December 11, 2010
Format: Paperback Verified Purchase
It's outdated, but the price was right. Good for me since I just wanted to get started with the concepts of ADO.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Want to discover more products? Check out these pages to see more: ada, web programming