Hitch-hiker's Guide to Visual Basic and SQL Server

The HITCHHIKER'S GUIDE TO VISUAL BASIC AND SQL SERVER, Sixth Edition, is for hands-on developers, development managers in medium-sized to large MIS development shops, and everyone else who wants to use Visual Basic to tap the power of SQL Server. Readers need a working knowledge of Visual Basic, an understanding of how SQL Server is administered, and the ability to create Transact-SQL commands and batches. The enclosed CD-ROM contains sample code from the book, a sample database, white papers, The Microsoft SQL Server Developer's Resource Kit, archived VBSQL and ODBC API chapters from the fifth edition and more.

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