Visual Basic Database Programming (With CD-ROM) - Hardcover

Kofler, Michael

Hardcover

ISBN 10: 0201721937 ISBN 13: 9780201721935

Publisher: Addison-Wesley, 2001

Synopsis

Provides the Visual Basic programmer with the practical advice needed to master client-server database systems. Based on real-life examples, the text offers a detailed introduction to ADO (ActiveX Data Objects) and to the various database productivity tools integrated into Visual Basic. Also provides guidance on programming techniques allowing access to database servers such as MSQL Server. CD-ROM contains all sample code, 100 Mbyte sample database, and MSDE. Annotation c. Book News, Inc., Portland, OR (booknews.com)

About this title

About the Author

Michael Kofler is an accomplished and award-winning author of many succesful technical books on subjects including Visual Basic, Linux, Maple, and MySQL, published both in German and in English. 0201721937AB10012001

From the Back Cover

If you are a Visual Basic programmer, this book will provide you with all the practical advice you need to master working with databases on client/server systems. Using real-life examples, this book provides a thorough and detailed introduction to ADO (ActiveX Data Objects) and to the various database productivity tools integrated into Visual Basic. It also offers a wealth of practical guidance on programming techniques allowing access to database servers such as MSQL Server. The book covers:

• Different Ado cursor types
• The advantages of stored procedures
• Application of ADO controls
• Distribution of VB database applications
• Internet access via WebClass objects
• Compact reference of ADO 2.1 objects and controls

All examples are based on SQL Server 7, and the book also gives detailed information about the Microsoft Data Engine (MSDE), which is ideal for smaller database projects; if required MSDE can be updated to SQL Server without any change of code.

This book:

• Deals with problems as they appear in the real world, not as they are documented by Microsoft
• Explains practical techniques which will optimize database performance
• Provides guidance on dealing with problems encountered during with MSDE deployment
• Introduces database administration using the SQLDMO library

CD-Rom contains:

• All sample code
• 100 Mbyte sample database
• MSDE

0201721937B10012001

Excerpt. © Reprinted by permission. All rights reserved.

If we are to believe Microsoftís marketing department, constructing a database application with Visual Basic takes only a couple of mouse clicks -- countless wizards and designers do most of the hard work. In fact, it is a miracle that there are any programmers left! Admittedly, it looks different in practice: the conception and development of a database application require a wealth of experience, as well as a great deal of patience and nerve. This book aims to make professional database applications more approachable. As databases cannot be mastered overnight, further clarification is required here: this book is specifically aimed at those programmers who combine Visual Basic with a real client/server database. All examples, detailed solutions, and programming techniques introduced in this book are based on databases managed with the Microsoft SQL Server 7 or with the Microsoft Data Engine (MSDE). (Much information also applies to Jet databases, but this is included as incidental information only.) The Microsoft Data Engine requires a special mention at this point: this latest innovation from Microsoft has only been on the market since the launch of Office 2000. Although the MSDE was not marketed with Visual Basic 6 as standard, it was of great significance for all VB programmers: it meant that modern database technology could be used in supporting proportionately small projects. The MSDE is a somewhat limited, yet completely compatible, version of the Microsoft SQL Server. The distinctive feature is that the MSDE may be distributed with programs which were developed with the VB Professional or Enterprise version free of charge! This is not exclusively a hands-on guide to Visual Basic, quite simply because VB alone is insufficient in developing an efficient client/server application. A special emphasis is therefore placed on the basic principles of the interaction between VB code, the ADO library, and the SQL Server. If you try to increase the efficiency of a VB program by using stored procedures (these are SQL procedures executed by the server), you will immediately recognize why modern VB database development simply is not possible without a basic knowledge of SQL or an understanding of the concepts of relational databases. This book shows you how to piece together the Microsoft jigsaw puzzle of components, libraries, servers, etc. and apply it in a stable and efficient manner. I wish you the very best of luck! Michael Kofler kofler.cc 0201721937P08152001

Edition details

• Publisher: Addison-Wesley
• Publication date: 2001
• Language: English
• ISBN 10: 0201721937
• ISBN 13: 9780201721935
• Binding: Hardcover
• Number of pages: 448