Troubleshooting IIS 4.0 and Visual InterDev 6.0 by Ken Spencer Published by 29th StreetPress Dec.98; $24.95US; 1-58304-029-3 148 pages Chapter 2 Using Active Server Pages (ASP) and HTML

INTRODUCTION AND TABLE OF CONTENTS Page 1: APPLICATION AND SESSION VARIABLES Page 2: USING THE VISUAL INTERDEV 6.0 SCRIPT DEBUGGER Page 3: SCRIPTING

Problem:
You face the challenge of using Internet Information Server (IIS 4.0) and Visual InterDev 6.0 -- and need a quick but thorough reference.

You value the power of IIS 4.0 and Visual InterDev 6.0 to build applications for the Internet and for corporate intranets/extranets -- but you want an insider's scoop on managing them effectively.

Solution:
Ken Spencer has worked with IIS and Visual InterDev since their early preview stages. Now he takes knowledge selected from his development and system management experiences and from teaching more than a thousand seminar attendees -- and condenses it for you.

The problem/solution format in this book lets you grasp and use crucial information fast. The many screen shots help you apply solutions with confidence. The extensive index makes finding what you need to know easy. To get answers to your questions -- quickly -- keep this pocket reference with you at all times.

Key features:

• Easy-to-use problem/solution format
• Real-world problems and their solutions
• Tips for installing IIS 4.0 and Visual InterDev 6.0
• Pointers for using ASP, database applications, and COM components
• Tips for optimizing IIS 4.0 performance
• Troubleshooting IIS 4.0 and Visual InterDev security
• Chapter checklists and detailed index
• Handy size
• References to Microsoft Knowledge Base articles for more information

Ken Spencer is with 32X, a firm specializing in training seminars. Ken has written and co-authored several books, including Client/Server Programming with Microsoft Visual Basic and Inside Visual InterDev. He can be reached at KenSpencer@32x.com. Ken is a contributing editor for Windows NT Magazine.

Table of Contents

Preface viii
About the Series Editor x
Introduction xi

Chapter 1 Installing Internet Information Server (IIS) 4.0 and Visual InterDev 6.0 1
Checklist 1
Preparing to Install IIS 4.0 2
IIS Server Extensions 5
FrontPage Server Extensions 6
Visual InterDev RAD Extensions 6
Order of Installation for Server Software 6
Installing IIS 4.0 8
Installing Visual InterDev 6.0 12
Performing the Installation 13

Chapter 2 Using Active Server Pages (ASP) and HTML 19
Checklist 19
The ASP Processor 20
Application and Session Variables 20
Using the Visual InterDev 6.0 Script Debugger 24
Scripting 26

Chapter 3 Using COM Components with IIS 4.0 and Visual InterDev 6.0 37
Checklist 37
Registering COM Components 38
Troubleshooting COM Components 41
Using Out-of-Process Components 46
COM Components and Scaling Up 48

Chapter 4 Using Database Applications with IIS 4.0 and Visual InterDev 6.0 49
Checklist 49
Data Sources 50
Using the Data Environment 51
Database Problems 53
Registry 59
SQL Server 60
Recordsets 70
General Database Errors 72
More on Drivers 78
Where Is the Latest Microsoft SQL Server Driver? 78
Where Is the Latest Microsoft Oracle Driver? 79
Where Are the Latest Access, Paradox, dBASE, FoxPro, Excel, and Text Drivers? 79
Determining the Current Version of a SQL Server Driver 79
Tracing ODBC Application Database Calls 79
ODBC Connection Pooling 80
How Does ODBC Connection Pooling Affect an Application? 80
Troubleshooting Remote Data Service 82
Database Application Performance Issues 83
Holding References to Database Objects 83
Choosing a Database OLE DB Provider 83
Increasing the Record Cache 83

Chapter 5 Managing IIS 4.0 87
Checklist 87
Proactive Management for IIS 4.0 88
Tools of the Trade 89
Microsoft Technical Support 90
Internet Service Manager 90
Inheritance of Property Changes 92
IIS 4.0 and the Metabase 94
Windows Scripting Host 95
Metabase Editor 96
WWW Service 97
Command Prompt 97
Server Components 97

Chapter 6 Optimizing IIS 4.0 Performance 101
Checklist 101
Optimizing Server Performance 102
Tools of the Trade 103
Windows NT Services and IIS 4.0 104
Optimizing Processor Use 105
Optimizing Memory Use 110
Monitor Memory Use 111
Stop a Pool Leak 114
Limit the Number of Connections 114
Optimizing Network Use 114
Monitoring TCP/IP Connections 118
Monitoring Network Bandwidth 119
Monitoring IIS 4.0 Traffic 122
Optimizing Disk Use 125
ASP vs. HTM Overhead 127
When to Use MTS 128
When to Use MSMQ 128

Chapter 7 Troubleshooting Security with IIS 4.0 and Visual InterDev 6.0 129
Checklist 129
Security Overview 130
Security Administration 130
Using Certificates 132
Effects of Metabase Settings 133
Secure Sockets Layer (SSL) Issues 135
Authentication Issues 136
Security and Performance 140

Index 141

INTRODUCTION AND TABLE OF CONTENTS Page 1: APPLICATION AND SESSION VARIABLES Page 2: USING THE VISUAL INTERDEV 6.0 SCRIPT DEBUGGER Page 3: SCRIPTING

Copyright © 1999 Ken Spencer