The ADO 2.6 Programmer's Reference provides a concise and comprehensive guide to the ways in which ADO 2.6 can be used in all kinds of applications. It demonstrates the use of ADO both in Web applications written using ASP, and in compiled applications written using Visual Basic and other languages. It also includes a reference section for fast access to detailed lists of the properties, methods and events available in ADO.
Useful for anyone who programs with databases on Windows, the new edition of
ADO 2.6 Programmer's Reference is an up-to-the-minute source of information on the latest features available in ActiveX Data Objects (ADO) and related standards from Microsoft. Besides being a handy resource 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 the bases with Microsoft Universal Data Access (UDA) strategy. You learn what works best when connecting to record-sets 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 bugs and known gotchas for particular objects are provided in abundance. The charts listing features supported by various OLE DB providers are also useful. You get specific suggestions about which APIs to use, plus some benchmarking of various cursor types and database programming strategies (comparing stored procedures, parameterised queries and hard-coded SQL within ADO code).
Reference material naturally makes up the heart of this text. With over 250 p pages on all important ADO standards (including RDS, ADOX, ADOMD, and JRO), a all properties, methods, events, constants, and even error codes are l 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 are entirely new to Microsoft databases, this patient and very thorough tour of ADO can help you get productive with database development on today's Windows quickly. --Richard Dragan