Product Description

This book explains, demonstrates, and applies techniques that intersect with two great tools of the Information Age. The first tool&emdash; the database&emdash;is relatively old. While the second tool, the Internet, is still quite young. And when you pair these tools&emdash;voila! You can create powerful web pages.

With the help of this book, you will learn to incorporate databases into your ASP applications using ADO (which provides a set of objects that you can connect to, read from, and write to). You'll gain comfort installing necessary software handling stored procedures. And this book will answer many real-world questions, complete with code for you to copy and paste.

Product Details

• Amazon Sales Rank: #843026 in Books
• Published on: 2003-08-26
• Original language: English
• Number of items: 1
• Binding: Paperback
• 856 pages

Amazon.com Review
As a tutorial, Beginning ASP Databases offers an entry point to one of the most crucial aspects of Microsoft-oriented Web development--database integration with Active Server Pages. In Beginning ASP Databases, a trio of authors covers the basics of working with databases from ASP--especially using ActiveX Database Objects (ADO).

The book is quite substantive in content but is written in a somewhat light-hearted style that makes readers new to the technology comfortable. The authors begin with a discussion of the benefits of ASP and ADO, and then explain how to configure the technology on the various flavors of Windows. From there, they show how to access databases using ADO, demystify how it all works, and focus on several key areas, including debugging, SQL, and stored procedures.

Plenty of code examples are included, and each is captioned with step-by-step explanations. Exercises and quizzes also complement the material. Throughout the book the authors identify some quite useful techniques to employ and traps to watch for--nuggets of knowledge that will set new ASP programmers on the right track. A lengthy case study ties it all together with a real-world example.

If you're planning on building Web sites on the Microsoft platform, ASP/ADO database access knowledge is essential. This fine guide offers an excellent way to get up to speed seamlessly. --Stephen W. Plain

Topics covered: ADO/OLE DB architecture, SQL, recordsets, databases and cookies, error handling, command object, stored procedures, irregular data handling, performance testing and tuning.

From the Publisher
This book has been selected by the editors of Wrox Press to be part of the Wroxbase website.

Online discussion of the topics in this book available at Wrox's P2P site.

The publication is well suited to the following groups: - Readers of Beginning Active Server Pages 2.0 who want to make the next logical step and connect web sites to datastores

- Programmers from the database community who now want to implement their solutions with a Web interface. These folks have plenty of experience with database programming, but want to translate that knowledge into ADO solutions in ASP pages

- Web designers with an education in graphics design or word processing and some sense of programming. These people can benefit from the book by learning how to take their visually appealing sites and give them the business power of database connectivity

About the Author
John Kauffman earned a pair of degrees in the sciences from The Pennsylvania State University. He then conducted research for Hershey Foods in the genetics of the cacao tree and the molecular biology of chocolate production. John now divides his freelance consulting time evenly between teaching, writing, and programming, primarily in the areas of Visual Basic, Word macros, Access and Access Programming, and ASP. John is available for contract training in Asia, Europe, and North America by contacting Training@Kauffmans.org

Kevin Spencer started programming in C in the early 1990s and wrote a number of shareware programs for DOS, most of which were door programs for BBSs. In the process, he learned to construct relational databases in C, and later worked with Microsoft Visual FoxPro and Access. As Internet database connectivity technologies began to emerge from Microsoft, he learned them as well. He then started his own business, Site Design by TAKempis, which specializes in Internet database application programming with ASP/ADO. Microsoft awarded him with the MVP award in 1997. He has written articles about Microsoft FrontPage and ASP/ADO for several online magazines, including ASP Today.

Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Customer Reviews

A gem. Six stars! Should win the technical Pulizter prize.
The missing link for ASP web developers who are ready for databases connectivity. You do not need to know ASP to benefit from this book. I did not. Using a simple format the author takes you from basic ASP installation, to building HTML forms which add, delete, and update information on your local DB server. Every word in the book is carefully worded so you never second guess the author's intentions. Things to note: The book's database and scripting focus is Access and VBscript. But It is easy to create the example DB tables in SQL Server - that's what I did. Download a single file from the WROX website and all of the working examples in the book are at your disposal. You don't waste any time figuring out coding problems, Instead your main focus is reviewing the code and analyzing how it worked so well. This book is better than any $1500 ASP training course. It is the single Web development resource which connects all of the pieces together for you. Thanks John!

Excellent tutorial and overview of using ADO with ASP
This book is a great introduction to accessing databases using ASP. Data access is via ADO, and both Jet (MS Access) and SQL Server database examples are provided. In addition to just showing how to connect to a database through ASP, the book also shows many practical examples of when and why you would want to do so, and also provides a good case study illustrating an entire web application including such features as user logins, basic security, and cookies (as well as of course plenty of database access through ADO and dynamic asp pages).

This book would be a good first book for a programmer wanting to learn ASP and ASP Database technology, as complete code samples and explanations are provided for all asp code given, but it is also a good follow up book to Beginning ASP (ver 3.0 is about to be released)

(I was a member of the technical review team for this book, so I have read every word of the book and run every code sample.)

Wrox Publishing Scores Again!
If you aren't familiar with Wrox Publishing (great books!), Wrox has a learning tree on the back of most of their books. It helps developers determine the appropriate path and books to read to learn a specific technology. As a developer, I can't stress the importance of this enough. I therefore feel it's important to suggest that while this is a Beginning ASP book, you should have some experience coding straight Active Server Pages (no database stuff) and if you like Wrox, I highly suggest Beginning Active Server Pages 2.0 or 3.0 (I reviewed 2.0 if you need help determining which version book to get). If I hadn't gone through Beginning ASP 2.0 before doing this book, I wouldn't have gotten as much out of it. This is because the author immediately dives in to ADO in Chapter 3, assuming you are ASP-ready!

Having said that, this is a great book. I was familiar with Microsoft data access techniques (ADO, Jet, SQL language) and a little with ASP but I really needed a book to see how they all tied together. The author goes through SQL as does most any database book, but at least he uses it in the context of integrating with your ASP web pages. A great part of this book is showing how you would actually implement recordsets. In other words, he doesn't say "Here's how to bring back recordsets", he says "Here's how to bring back recordsets and display the information usefully in an ASP page". Cookies, Errors, Stored Procedures, and a full case study are all presented in later chapters. The case study was extremely helpful.

One other thing I think you may find helpful-- don't feel left out if you are only developing on a workstation with no server right now. You can still use this book. Chapter 2 is dedicated solely to showing how you can work with this entire book using/installing Personal Web Server, IIS, ADO on any Microsoft operating system, including Windows 95/98, 2000, Or NT with no server involved.