Accessing Databases in IIS Applications

This section describes how to access databases from IIS applications. IIS offers the Web developer flexible, easy-to-use, scalable methods to interact with OLE DB database providers for Internet or intranet applications. Using the ActiveX Data Objects (ADO) not only means that you can initially develop a solution using Access and scale up to SQL Server, but that you can access any other databases that have OLE DB providers. With the additional power of Component Services, you can create highly scalable multi-tier applications that support Web-based transactions.

This section includes the following topics:

• Accessing Data with ADO

• Creating a Guestbook

• Displaying an Excel Spreadsheet

• Using Stored Procedures with ADO

• Choosing the Client Networking Library for ADO

• Remote Data Binding with Remote Data Service

• Optimizing the Performance of Database Access in IIS