Through extensive real-world examples, this book shows exactly how to integrate Web sites and Microsoft SQL Server databases to solve real-world business problems. The book begins with an overview of Microsoft SQL Server, NT4 Server and Microsoft's Internet development tools, including Internet Information Server, FrontPage and Visual Basic. Walk through setting up NT's Web services; creating a database for Web use; and establishing connections via ODBC, remote data objects and/or Active Server Pages. Learn how to protect your site with the security features built into both NT 4.0 and SQL Server. Then, move on to more advanced topics, including Web queries via ActiveX controls and VB scripts; using SQL as a commerce server; working with Visual InterDev; building more advanced pages; and managing your site for maximum effectiveness.
Book Description
Editorial Reviews
From the Inside Flap
Introduction
Building a Web presence has become a very real business requirement in this day. It has come to the point in many industries, that a company without a presence on the Internet is no longer competitive. This is especially true for companies that compete the large market places-regional, national, and global.
Without this point of presence, many potential customers will not find you and your company. One of the primary uses for the Internet is to conduct research into companies and products. If a customer is looking for a company that produces a certain kind of product or has a specific manufacturing process available, they will search through the Web. If you do not have an Internet point of presence, then your company will not appear in the customers' research and you will not have a chance at the business.
Building a Web site, and then working to ensure that it can be easily found by users working with the many search engines throughout the Internet will be a key point in many company's survival into the next millennia.
Who This Book Is For
This book is aimed at anyone who wants to learn more about creating an interactive Web site that uses a new or existing SQL Server 7 database as the back end. This will be especially useful for those who are planning to use Windows NT Server 4 and Internet Information Server as platform for a Web server.
In writing this book, I have not made any assumptions about the skill level that you bring to your project. This book can be used by both the beginner, who needs to learn about many different topics, and the skilled SQL Server database administrator who only needs to know how to build a Web-enabled application that can connect to their database.
What You'll Need
In order to get the most from this book you must have a working copy of the Microsoft SQL Server 7 database application. In addition, you will find that being able to work with the Microsoft Windows NT Server 4 operating system and Microsoft Internet Information Server, will be the easiest. If you do not have access to a system with this operating system, you can successfully use either Windows 95 or 98, or Windows NT Workstation 4 and Microsoft Personal Web Server.
How This Book Is Organized
This book consists of thirteen chapters divided into four parts. While each of these parts build on the one before it, if you are familiar with the information contained in an earlier section, you would be able to skip about.
Part One: Your Company and the Internet
This first part consists of five chapters and covers the following information:
Chapter One: Why Build a Web Site With SQL Server? This chapter covers basic information about why you might want to build a Web-enabled database application. Chapter Two: Microsoft SQL Server as a Web-Enabled Database In this chapter you are introduced to the reasons for using SQL Server 7 as your database of choice when building a Web site. Chapter Three: The Microsoft Windows NT 4.0 Server Environment Here you learn about the various versions of the Windows operating system, and which is the best choice for your specific application. Chapter Four: Security This chapter discusses the need for security when building an Internet application and how the security features of both Windows NT Server 4 and SQL Server 7 are integrated. Chapter Five: SQL Installation and Set-up Here you learn to install and troubleshoot the installation of SQL Server 7. Part Two: Web Basics
This part introduces you to the basics you will need to connect your database to the Internet.
Chapter Six: Connecting to Your Database This chapter discusses the various methods you can use to connect to the back end database through the Internet. Chapter Seven: Web Site Design Tools Here you learn about the various options you have available for tools that you can use to build your Web site and connect it to your database. Chapter Eight: Connections In this chapter, the various types of connections to the Internet you can build. Chapter Nine: Setting Up NT's Web Services This chapter discusses how to setup the necessary NT Server 4 web services for your application. Part Three: Advanced Web Features
In Part Three, you learn more about building a Web-enabled database application.
Chapter Ten: Building Your Site In this chapter you build an application that uses both HTML and ASP pages. Chapter Eleven: Commerce on the Internet This chapter discusses several methods of conducting commerce on the Internet and additional applications that you may want to consider using. Chapter Twelve: Advanced Web Pages In this chapter you learn how to work with secure transactions. Part Four: Web Site Maintenance
Part Four considers the final topic of maintaining your site.
Chapter Thirteen: Information and Your Web Site In this chapter, you learn about various methods of ensuring that your site gets the traffic it needs and how to improve your site. Conventions Used In This Book
There are several very simple conventions used throughout this book to help you distinguish between text, figures, examples, and code.
All figures and tables are numbered and captioned so that you can quickly see what is being shown.
Examples and steps that you are to follow in an example are all numbered consecutively. Many of the figures will follow along with a step so that you are shown exactly what you should be doing.
Code, and things to be typed are all displayed in a monospaced type face, like this.
About the CD-ROM
This book includes a CD-ROM that contains a sample web site built using the examples in this book. The CD also features a computer-based training (CBT) module from CBT Systems, and a free copy of Microsoft's SQL Server 7.0 (120-Day Evaluation Edition). See the "About the CD-ROM" and "About SQL Server 7.0" sections at the end of the book for further details on the CD-ROM contents, installation instructions, and system requirements.
About the Author
Jeffry Byrne is a database developer and system administrator living in Portland, Oregon. His many books include Understanding Microsoft SQL Server and MCSE: Administering Microsoft SQL Server 7, both from Prentice Hall PTR.
Acknowledgments
A book dedicated to showing how to create an object as complex as a Web-enabled database does not come into fruition without a great deal of help. I must thank Jeffrey Pepper for asking me to do the project. Without the able assistance and considerable prodding from Jim Markham, and technical insights from John Vacca, this book may still be a manuscript. Thanks also to Nick Radhuber and his most able production staff for helping to catch any spelling and grammatical errors. Any remaining errors are my own.
Building a Web presence has become a very real business requirement in this day. It has come to the point in many industries, that a company without a presence on the Internet is no longer competitive. This is especially true for companies that compete the large market places-regional, national, and global.
Without this point of presence, many potential customers will not find you and your company. One of the primary uses for the Internet is to conduct research into companies and products. If a customer is looking for a company that produces a certain kind of product or has a specific manufacturing process available, they will search through the Web. If you do not have an Internet point of presence, then your company will not appear in the customers' research and you will not have a chance at the business.
Building a Web site, and then working to ensure that it can be easily found by users working with the many search engines throughout the Internet will be a key point in many company's survival into the next millennia.
Who This Book Is For
This book is aimed at anyone who wants to learn more about creating an interactive Web site that uses a new or existing SQL Server 7 database as the back end. This will be especially useful for those who are planning to use Windows NT Server 4 and Internet Information Server as platform for a Web server.
In writing this book, I have not made any assumptions about the skill level that you bring to your project. This book can be used by both the beginner, who needs to learn about many different topics, and the skilled SQL Server database administrator who only needs to know how to build a Web-enabled application that can connect to their database.
What You'll Need
In order to get the most from this book you must have a working copy of the Microsoft SQL Server 7 database application. In addition, you will find that being able to work with the Microsoft Windows NT Server 4 operating system and Microsoft Internet Information Server, will be the easiest. If you do not have access to a system with this operating system, you can successfully use either Windows 95 or 98, or Windows NT Workstation 4 and Microsoft Personal Web Server.
How This Book Is Organized
This book consists of thirteen chapters divided into four parts. While each of these parts build on the one before it, if you are familiar with the information contained in an earlier section, you would be able to skip about.
Part One: Your Company and the Internet
This first part consists of five chapters and covers the following information:
Chapter One: Why Build a Web Site With SQL Server? This chapter covers basic information about why you might want to build a Web-enabled database application. Chapter Two: Microsoft SQL Server as a Web-Enabled Database In this chapter you are introduced to the reasons for using SQL Server 7 as your database of choice when building a Web site. Chapter Three: The Microsoft Windows NT 4.0 Server Environment Here you learn about the various versions of the Windows operating system, and which is the best choice for your specific application. Chapter Four: Security This chapter discusses the need for security when building an Internet application and how the security features of both Windows NT Server 4 and SQL Server 7 are integrated. Chapter Five: SQL Installation and Set-up Here you learn to install and troubleshoot the installation of SQL Server 7. Part Two: Web Basics
This part introduces you to the basics you will need to connect your database to the Internet.
Chapter Six: Connecting to Your Database This chapter discusses the various methods you can use to connect to the back end database through the Internet. Chapter Seven: Web Site Design Tools Here you learn about the various options you have available for tools that you can use to build your Web site and connect it to your database. Chapter Eight: Connections In this chapter, the various types of connections to the Internet you can build. Chapter Nine: Setting Up NT's Web Services This chapter discusses how to setup the necessary NT Server 4 web services for your application. Part Three: Advanced Web Features
In Part Three, you learn more about building a Web-enabled database application.
Chapter Ten: Building Your Site In this chapter you build an application that uses both HTML and ASP pages. Chapter Eleven: Commerce on the Internet This chapter discusses several methods of conducting commerce on the Internet and additional applications that you may want to consider using. Chapter Twelve: Advanced Web Pages In this chapter you learn how to work with secure transactions. Part Four: Web Site Maintenance
Part Four considers the final topic of maintaining your site.
Chapter Thirteen: Information and Your Web Site In this chapter, you learn about various methods of ensuring that your site gets the traffic it needs and how to improve your site. Conventions Used In This Book
There are several very simple conventions used throughout this book to help you distinguish between text, figures, examples, and code.
All figures and tables are numbered and captioned so that you can quickly see what is being shown.
Examples and steps that you are to follow in an example are all numbered consecutively. Many of the figures will follow along with a step so that you are shown exactly what you should be doing.
Code, and things to be typed are all displayed in a monospaced type face, like this.
About the CD-ROM
This book includes a CD-ROM that contains a sample web site built using the examples in this book. The CD also features a computer-based training (CBT) module from CBT Systems, and a free copy of Microsoft's SQL Server 7.0 (120-Day Evaluation Edition). See the "About the CD-ROM" and "About SQL Server 7.0" sections at the end of the book for further details on the CD-ROM contents, installation instructions, and system requirements.
About the Author
Jeffry Byrne is a database developer and system administrator living in Portland, Oregon. His many books include Understanding Microsoft SQL Server and MCSE: Administering Microsoft SQL Server 7, both from Prentice Hall PTR.
Acknowledgments
A book dedicated to showing how to create an object as complex as a Web-enabled database does not come into fruition without a great deal of help. I must thank Jeffrey Pepper for asking me to do the project. Without the able assistance and considerable prodding from Jim Markham, and technical insights from John Vacca, this book may still be a manuscript. Thanks also to Nick Radhuber and his most able production staff for helping to catch any spelling and grammatical errors. Any remaining errors are my own.
From the Back Cover
* Step-by-step coverage of integrating Web sites and SQL Server databases
* Covers every data access option: ODBC, remote data objects, Active Server Pages, and more
* Using SQL Server 7 as a commerce server: techniques and solutions
* Detailed coverage of enhancing Web database security
* Using Visual InterDev, VBScript, and ActiveX controls
* Managing your database-enabled site
The complete, step-by-step guide to integrating your Web site and Microsoft SQL Server 7 database!
Building Microsoft® SQL Server™ 7 Web Sites is the first start-to-finish guide to database-enabling your Web site with Microsoft SQL Server 7. Using detailed examples built to solve real-world business problems, database expert Jeffry Byrne covers every key Microsoft technology for Web/database integration, showing exactly when to use each option—and how to avoid the pitfalls.
Start with an overview of SQL Server 7, NT Server 4, Internet Information Server, FrontPage 98, VB6, and other key elements of a Microsoft Web/database solution. Next, walk through setting up NT's Web services; creating a database for your Web application; and choosing the right data access solution—ODBC, remote data objects and/or Active Server Pages.
Discover how to protect your site using both NT 4.0 Server and SQL Server security features. Build Web queries via ActiveX controls and VBScript; learn how to use SQL as a commerce server; get results with Visual InterDev; and manage your site for maximum effectiveness. Complete, practical, and business-focused, Building Microsoft® SQL Server™ 7 Web Sites is all you need to database-enable your site—fast!
CD-ROM Included
The accompanying CD-ROM includes sample Web application with sample code, plus free and trial version of Microsoft's database server SQL Server 7.0 and an interactive training course from CBT Systems, the world's #1 developer of IT self-paced training.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
19 of 20 people found the following review helpful:
2.0 out of 5 stars
Not much useful for reasonably adept developers,
This review is from: Building Microsoft SQL Server 7 Web Sites (Paperback)
Having worked with Access for a long time, I wanted a book that would help with constructing sites in SQL Server. This book was way too simplistic and spends far too much time on installing NT and IIS, and not enough on 'building sites with SQL Server'. Only cursory look at ASP code to actually interact with your site, almost all of it via Interdev. Index is lacking in detail, even common interface elements. If you're a very beginner, then maybe this book will be good for you, but I'd look elsewhere.
8 of 8 people found the following review helpful:
2.0 out of 5 stars
It's for beginners.,
By A Customer
This review is from: Building Microsoft SQL Server 7 Web Sites (Paperback)
If you already know how to set up NT server, IIS and SQL, this book is not for you. There are not much useful information for serious developers.
8 of 8 people found the following review helpful:
1.0 out of 5 stars
Great title, but doesn't deliver on content.,
By
This review is from: Building Microsoft SQL Server 7 Web Sites (Paperback)
Most of the book covers basic set-ups for NT, IIS, SQL Server. The same information that is standard with these products. What the book covers on building MS SQL Server 7 Web sites could fit in a pamphlet. Save your money!
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Listmania!
So You'd Like to...
Look for Similar Items by Category
- Books > Computers & Technology > Databases > SQL
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Microsoft > Networking
- Books > Computers & Technology > Networking > Networks, Protocols & APIs
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Web Development > Programming
- Books > Computers & Technology > Web Development > Web Design
- Books > Computers & Technology > Web Development > Web Services
