Hitchhiker's Guide to Visual Basic and SQL Server, 6th Edition - Softcover

Vaughn, William R.

 
9781572318489: Hitchhiker's Guide to Visual Basic and SQL Server, 6th Edition

Synopsis

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.

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

Review

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

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