The SQL Server 2000 Web Architecture

Three major pieces provide Web access to SQL Server 2000 databases. The SQL Web component (also known as the ISAPI component) accepts database commands in HTTP requests from Web clients (e.g., browsers) and returns HTTP responses. The Microsoft data access components accept queries in either conventional SQL or the new XPath query language, along with formatting instructions, and return results as XML, HTML, or binary documents. The SQL Server 2000 database server accepts SQL commands and returns either XML or binary results; the data access components translate commands into SQL for the database server and format the results it returns.

These components can support application architectures other than the one shown here. For example, in an Active Server Pages (ASP) Web application, a set of custom ASPs take the place of the SQL Web component. In a client/server application, a custom user interface component (e.g., a Visual Basic data-entry program) and the data access components both reside on the client machine.