Visual Basic 6 Database Programming Bible - Softcover

Freeze, Wayne S.

Softcover

ISBN 10: 0764547283 ISBN 13: 9780764547287

Publisher: John Wiley & Sons Inc, 2000

Synopsis

Explains how to design and build a wide range of client/server and web-based database applications using Visual Basic 6.0, ActiveX Data Objects 2.5, and SQL Server 7.0, in a handbook that features helpful tutorials, step-by-step directions, code amples, and practice applications. Original. (Intermediate)

About this title

Review

It takes exposure to quite a few tools and APIs to be successful with database development today. The Visual Basic 6 Database Programming Bible lets the beginning reader master what's really important, with a wide-ranging and effective tutorial on databases, along with some excellent coverage of the latest in XML and Oracle support in VB.

This book starts from the ground up, with a nicely digestible tour of the essentials of databases and SQL that's aimed at the beginner. Of course, it's de rigueur for VB titles to cover ActiveX Data Objects (ADOs), Microsoft's recommended set of objects for database programming. This book does a good job here, with three excellent chapters on how to be effective with ADO within your VB programs, both with "bound" controls and through custom code. Besides the fundamentals of ADO, this title also will serve as a handy reference, as each section lists all of the objects and methods that you'll need to use everyday. Other sections look at COM+ transactions and message-queue services, which provide much of the power for building robust, scalable database applications on the Microsoft Windows platform.

But this text goes much further than the "official" Microsoft way, with excellent coverage of administering and programming stored procedures on Oracle 8i (as well as MS SQL Server 7.0). With plenty of screen shots, this book does a great job of demystifying Oracle, and helps put this popular database into the reach of any VB developer. Several sections even look at XML done in VB, along with a basic tutorial of what XML is and how to combine it with ADO to deliver intermediate datasets. It's this cross-vendor perspective that distinguishes Visual Basic 6 Database Programming Bible from the rest of the pack. Clearly, today's VB programmers no longer can afford to have a narrow, Microsoft-only focus. This up-to-date text will help you gain a wider view of some of the more popular APIs and tools that you'll need to use to succeed with VB in real software for real organizations. --Richard Dragan

Topics covered: History and overview of databases, relational databases, basic database-design principles: tables, views, and indexes; ODBC, RDO, and ADO database connectivity compared; SQL primer, introduction to Visual Basic 6 and tools, "codeless" database applications with bound controls, report design with the Microsoft Data Report Designer, ADO 2.5 (and ADOX) objects and methods, using SQL stored procedures and the Command object, writing and debugging stored procedures, the Connection, Recordset, and Field objects; basic COM+ principles, building custom VB COM objects, transaction basics with COM+, message queues and asynchronous messaging, XML tutorial (XML, XSL, and the XML Document Object Model), XML used with ADO and IIS applications, SQL Server 7.0 and Oracle 8i administration and database-programming tutorials (including stored procedures on both platforms), and a tutorial for the Microsoft Jet database engine.

From the Publisher

Inside you'll find complete coverage of Visual Basic database programming:

Jump start your programming with Data Environments and Data Report Designer

Harness the power of the ADO 2.5 object model, from connections to commands

Integrate XML with Internet Information Server applications

Manipulate Recordsets to optimize the performance of your application

Create custom bound controls, COM+ transactions, and message queuing modules

Tailor an application for Microsoft SQL Server 7, Oracle 8i, or Microsoft Jet 3.51/4.0

Capitalize on custom utilities and SQL language extensions, such as PL/SQL

Construct platform-specific data types and manage security, logins, roles, and users

Edition details

• Publisher: John Wiley & Sons Inc
• Publication date: 2000
• ISBN 10: 0764547283
• ISBN 13: 9780764547287
• Binding: Paperback
• Language: English
• Number of pages: 728