ADO and SQL Server

ADO Web Application

This sample application demonstrates how to use ADO to build an Active Server Page (ASP) Web application that interacts with an instance of SQL Server. The sample models an inventory management system based on the Products and Categories tables in the Northwind database. The application allows you to view the products and categories, make updates to product information, add new products, and remove products.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\ADO\Web

Prerequisites

This ASP sample requires Microsoft® Internet Information Services (IIS) version 4.0 or later, or Microsoft Personal Web Server (PWS). IIS 4.0 for Microsoft Windows NT® Server and PWS for Windows 95, Windows 98, and Windows NT Workstation are included in the Windows NT Option Pack, which can be downloaded from Microsoft Web site. IIS 5.0 is included in Windows 2000 Server, Windows 2000 Advanced Server, and Windows 2000 Datacenter.

Running the Sample

Here are the steps for running the Northwind Inventory Management System application:

  1. Create a new Web page in IIS or PWS using the directory containing the sample files.

  2. Open the global.asa file in an editor, add the name of an instance of Microsoft SQL Server™ to the provider string variable, ProvStr, and then save the file.

  3. Start and browse the Web page from IIS or PWS to view the Northwind Inventory Management System application.
Remarks

To use this sample, you should have a basic understanding of Active Server Pages and IIS. For more information, see the MSDN Library at Microsoft Web site.

See Also

ADO Samples