Building Microsoft SQL Server 7 Web Sites

by BYRNE JEFFREY L.

• ISBN13: 9780130797636
• ISBN10: 0130797634
• Edition: 1st
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: Prentice Hall Ptr

Summary

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.

Author Biography

Jeffry Byrne is a database developer living in Portland, OR. His eleven software books include In Business with Access, Microsoft SQL Server: What Database Administrators Need to Know, and MCSE: Administering Microsoft SQL Server 7 (Prentice Hall PTR).

Table of Contents

Introduction	p. xiii
Who This Book Is For	p. xiii
What You'll Need	p. xiii
How This Book Is Organized	p. xiv
Conventions Used In This Book	p. xv
About the CD-ROM	p. xv
About the Author	p. xv
Acknowledgments	p. xvi
Your Company and the Internet
Why Build a Web Site with SQL Server?	p. 3
What Can the Internet Do for You?	p. 5
Internet Connections vs. intranet Connections	p. 13
Microsoft SQL Server as a Web-Enabled Database	p. 21
Why Microsoft SQL Server?	p. 21
The Microsoft NT Server 4.0 Environment	p. 39
Why Microsoft NT Server?	p. 39
Remote Access Service (RAS)	p. 44
Choosing an Operating System	p. 49
Security	p. 55
Why You Need Security	p. 55
Security Options	p. 58
Using Windows NT Security	p. 58
Mixed Security	p. 89
Using the Permissions System	p. 106
Firewall Security	p. 107
SQL Installation and Setup	p. 111
The Three Faces of SQL Server 7.0	p. 112
Operating System Requirements	p. 114
Hardware Requirements	p. 115
Required User Accounts	p. 116
Installing Microsoft SQL Server	p. 119
Alternative Setup Processes	p. 129
Troubleshooting Setup	p. 136
Building a Database	p. 137
Web Basics
Connecting to Your Database	p. 173
ODBC Connections	p. 173
Creating an Internet Database Connector File	p. 181
Defining Active Server Pages	p. 184
Creating Active Server Pages	p. 192
Web Site Design Tools	p. 197
Microsoft Internet Information Server	p. 197
Other Microsoft Internet Tools	p. 206
Browsers	p. 218
Connections	p. 221
Connecting to the Internet	p. 222
Selecting and Registering Your Name	p. 229
Setting Up NT's Web Services	p. 233
Microsoft Internet Information Server (IIS)	p. 234
Advanced Web Features
Building Your Site	p. 261
The Visual InterDev Working Environment	p. 262
Using Visual InterDev	p. 263
Pages and Scripts	p. 301
Commerce on the Internet	p. 339
Developing an e-Commerce Site	p. 340
More Tools	p. 340
A Simple Commerce Web Site	p. 344
Advanced Web Pages	p. 381
Securing Transactions	p. 382
Links to Other Web Sites	p. 401
Graphics: Why and Why Not?	p. 402
Web Site Maintenance
Information and Your Web Site	p. 407
Is Your Site Attracting Viewers?	p. 407
What Do Your Web Users Want?	p. 414
Critiquing Your Own Site	p. 419
Opinions	p. 422
Index	p. 425
Table of Contents provided by Syndetics. All Rights Reserved.