Professional ADO 2.5 Programming (Wrox Professional Guide) - Softcover

Conard, James; Blackburn, Ian; Matsik, Brian

9781861002754: Professional ADO 2.5 Programming (Wrox Professional Guide)

Softcover

ISBN 10: 1861002750 ISBN 13: 9781861002754

Publisher: Apress, 2000

All windows developers need to use ADO. ActiveX Data Objects (ADO) 2.5 is Microsoft's latest Data Access technology. It is used to enable fast and efficient data transfer between a database and the end users. What's more, ADO 2.5 works across a range of languages (VB, VC, ASP, Access, Office etc) and with a range of back-end databases - SQL Server 7, Oracle 8i, Access 2000 etc. Almost all developers work with some combination of these technologies, so they all need to know ADO.

"synopsis" may belong to another edition of this title.

Review:

Filled with late-breaking information on new APIs and standards, Professional ADO 2.5 Programming will make an invaluable resource for anyone who programs with databases on the Microsoft platform. Written for those with some previous experience with ADO, this richly presented text can definitely extend the reach of your database programming skills.

The best thing about this book has to be its comprehensive tour of Microsoft database APIs over the years (from ODBC, DAO, and RDO) to today's Universal Data Access (UDA) strategy centered on OLE DB and ADO. This book also shows where UDA fits in with Microsoft's recommended approach for building applications on the Web (which take advantage of multitiered architectures). If you want to manipulate database objects (such as modifying databases and tables), you'll want to look at the sections on ADOX. And if you find yourself having to write a custom OLE DB Provider, tutorial sections will show you how (plus there's a working sample of a custom provider that hooks into the Windows Registry).

There is plenty for the enterprise programmer, with coverage of the new Active Directory in Windows 2000, plus background on LDAP and using the ASDI interfaces for programming with corporate directory information. The book culminates with a useful case study on business-to-business e-commerce (for an online florist with virtual suppliers). Most of the code uses Visual Basic, though there is mention of Visual C++ as well. Reference sections on all ADO APIs (and constants) will help make this title a must for the working programmer.

There are many facets of today's database standards in the Microsoft platform. Professional ADO 2.5 Programming covers virtually all of them, with a detailed tour of a lot of useful information that can benefit any intermediate or advanced developer. --Richard Dragan

Topics covered: History of Microsoft database APIs, native APIs, ODBC, Data Access Objects (DAO), Remote Data Objects (RDO), Universal Data Access (UDA), Microsoft Data Access Components (MDAC), OLE DB providers and consumers, ActiveX Data Objects (ADO), ADODB and ADOR, using Visual C++ and Visual Basic with ADO, Remote Data Services (RDS), XML, Windows DNA and multitiered architectures, MTS, MSMQ, COM+, OLE DB Cursor and Synchronization Services, batch updates, persisting recordsets, asynchronous processing and event notification, data shaping and the SHAPE language, ADO and XML, Internet publishing, WebDAV and resource management, security, multidimensional data and OLAP, ADOX for manipulating database objects, performance tuning, ADSI and directory services, LDAP basics, Exchange Server 2000, and creating OLE DB Providers: guidelines and sample VB code, and an e-commerce business-to-business case study using ADO.

From the Publisher:

The book gives broad coverage of ADO 2.5 - including new features and shows how to implement ADO 2.5 into your applications. It also examines using ADO to access non-MS datastores and includes examples in C++, Java, VB and ASP. The book contains detailed, practical hands-on examples and discusses the new features of semi-structured data. It goes on to examine the growing role of XML as a data transfer mechanism.

"About this title" may belong to another edition of this title.