The new edition of this encyclopedic guide to data access is updated to cover Visual Basic 6.0. It includes thorough coverage of the new ActiveX Data Objects (ADO) interface, as well as RDO, ODBCDirect, and DAO/Jet data interfaces. Also covers designing and building applications, managing SQL Serve data and datacentric applications, and the Data Environment Designer, the Data Object Wizard, and other new data access tools. The included CD-ROM contains sample code and sample databases, archives from the fifth edition, and white papers, presentations, and other information. Annotation c. by Book News, Inc., Portland, Or.
Focusing on Visual Basic 6's new data-access resources,
Hitchhiker's Guide to Visual Basic and SQL Server is the definitive guide to Microsoft's database development tools. If you're concerned with creating a way for a Visual Basic application or control to talk to an SQL Server back end, this book most likely has the answers you need.
Microsoft has six major SQL interface solutions: Visual Basic SQL (VBSQL), Open Database Connectivity (ODBC), Data Access Objects (DAO)/Jet, DAO/ODBCDirect, Remote Data Objects (RDO), and ActiveX Data Objects (ADO). William Vaughn covers all of them in this book, plus the low-level SQL Server interfaces. He includes quite a lot of sample code (in the text and on the companion CD-ROM) that shows how different access mechanisms open connections, perform queries, and return values. Sidebars and other supplementary nuggets of text use the first person to great effect--they enable Vaughn to share his considerable experience in a straightforward way.
ADO, the apparent replacement for most of Microsoft's other database-access technologies, receives especially lavish treatment. The author details each part of an ADO-facilitated transaction, and goes into depth on how to build custom ADO objects and how (and whether) to convert from RDO to ADO.
If yours is a Microsoft shop, this book will prove invaluable in connecting people to the data they need. --David Wall