Beginning ASP Databases [Paperback]

Kevin Spencer (Author), Thearon Willis (Author), John Kauffman (Author)

Book Description

Publication Date: September 2, 2003 | ISBN-10: 1590592492 | ISBN-13: 978-1590592496

This book explains, demonstrates, and applies techniques that lie at the intersection of the two great tools of the Information Age. One tool, the database, is relatively old. The other, the Internet, is quite new. With these two tools together, readers can create powerful Web pages. In this book, readers will learn how to incorporate databases into their ASP applications using ADO, which provides a set of objects through which one can connect to, read from, and write to databases. From installing the necessary software and a basic guide to SQL, to handling stored procedures, readers will get several real-world questions answered with code ready to cut and paste and a chance to practice at every step of the way.

Editorial Reviews

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. --This text refers to an out of print or unavailable edition of this title.

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 --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 856 pages
• Publisher: Apress (September 2, 2003)
• Language: English
• ISBN-10: 1590592492
• ISBN-13: 978-1590592496
• Product Dimensions: 9 x 7.3 x 1.8 inches
• Shipping Weight: 2.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars  See all reviews (124 customer reviews)
• Amazon Best Sellers Rank: #1,266,666 in Books (See Top 100 in Books)
  • #60 in Books > Computers & Technology > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

114 of 114 people found the following review helpful:

5.0 out of 5 stars A gem. Six stars! Should win the technical Pulizter prize., December 24, 1999

By 

Stephen C Puchniak - See all my reviews

This review is from: Beginning ASP Databases (Paperback)

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!

82 of 83 people found the following review helpful:

5.0 out of 5 stars Excellent tutorial and overview of using ADO with ASP, October 19, 1999

By A Customer

This review is from: Beginning ASP Databases (Paperback)

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.)

22 of 22 people found the following review helpful:

5.0 out of 5 stars Wrox Publishing Scores Again!, January 12, 2001

By 

JRK "jkunz" (N.H.) - See all my reviews

This review is from: Beginning ASP Databases (Paperback)

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.