Cover image for Building Microsoft SQL Server 7 Web sites
Building Microsoft SQL Server 7 Web sites
Byrne, Jeffry.
Personal Author:
Publication Information:
Upper Saddle River, NJ : Prentice Hall, [1999]

Physical Description:
xvi, 436 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.).
General Note:
Author's name from cover.

Includes index.
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.C55 B89 1999 Book and Software Set Central Closed Stacks

On Order



* 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 NTs Web services; creating a database for your Web application; and choosing the right data access solution - ODBC, remote data objects and/or Act

Author Notes

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

Introductionp. xiii
Who This Book Is Forp. xiii
What You'll Needp. xiii
How This Book Is Organizedp. xiv
Conventions Used In This Bookp. xv
About the CD-ROMp. xv
About the Authorp. xv
Acknowledgmentsp. xvi
Part 1 Your Company and the Internet
1 Why Build a Web Site with SQL Server?p. 3
What Can the Internet Do for You?p. 5
Internet Connections vs. intranet Connectionsp. 13
2 Microsoft SQL Server as a Web-Enabled Databasep. 21
Why Microsoft SQL Server?p. 21
3 The Microsoft NT Server 4.0 Environmentp. 39
Why Microsoft NT Server?p. 39
Remote Access Service (RAS)p. 44
Choosing an Operating Systemp. 49
4 Securityp. 55
Why You Need Securityp. 55
Security Optionsp. 58
Using Windows NT Securityp. 58
Mixed Securityp. 89
Using the Permissions Systemp. 106
Firewall Securityp. 107
5 SQL Installation and Setupp. 111
The Three Faces of SQL Server 7.0p. 112
Operating System Requirementsp. 114
Hardware Requirementsp. 115
Required User Accountsp. 116
Installing Microsoft SQL Serverp. 119
Alternative Setup Processesp. 129
Troubleshooting Setupp. 136
Building a Databasep. 137
Part 2 Web Basics
6 Connecting to Your Databasep. 173
ODBC Connectionsp. 173
Creating an Internet Database Connector Filep. 181
Defining Active Server Pagesp. 184
Creating Active Server Pagesp. 192
7 Web Site Design Toolsp. 197
Microsoft Internet Information Serverp. 197
Other Microsoft Internet Toolsp. 206
Browsersp. 218
8 Connectionsp. 221
Connecting to the Internetp. 222
Selecting and Registering Your Namep. 229
9 Setting Up NT's Web Servicesp. 233
Microsoft Internet Information Server (IIS)p. 234
Part 3 Advanced Web Features
10 Building Your Sitep. 261
The Visual InterDev Working Environmentp. 262
Using Visual InterDevp. 263
Pages and Scriptsp. 301
11 Commerce on the Internetp. 339
Developing an e-Commerce Sitep. 340
More Toolsp. 340
A Simple Commerce Web Sitep. 344
12 Advanced Web Pagesp. 381
Securing Transactionsp. 382
Links to Other Web Sitesp. 401
Graphics: Why and Why Not?p. 402
Part 4 Web Site Maintenance
13 Information and Your Web Sitep. 407
Is Your Site Attracting Viewers?p. 407
What Do Your Web Users Want?p. 414
Critiquing Your Own Sitep. 419
Opinionsp. 422
Indexp. 425