One of the new features of Microsoft SQL Server 2000 is the support for XML, so that users can access the XML-capable SQL directly via HTTP
Server2000 database. The implementation method is described below.
System environment: Windows2000 Server (contains IIS) MS SQL
Server2000
Database: Classic database sample included with SQL Server2000: NorthWind
I. Configuring IIS and SQL
Server Virtual
Domains
1. New file directory
Open Windows Explorer and create a new directory under Inetpubwwwroot Northwind:
C:inetpubwwwrootorthwind
Create a new 2 subdirectory under the Northwind directory: template and Schema:
C:inetpubwwwrootwindemplate, for placing XML templates;
C:inetpubwwwrootwindschema, which is used to place the schema file.
2. Virtual directories that map IIS
In the SQL program group, select the Configure
SQL XML Support in
IIS, under Default site, select New, virtual path, and then perform a five-step standard configuration.
(1) on the "General" page, enter the virtual path name "Northwind" and map to the actual hard drive path, as shown in the figure.
alt= "" Hspace=0 src= "/upimg/20070212/11g214qpef1nw.jpg" Align=baseline
Border=0>
(2) on the "Security" page, select the appropriate login account and password. In this example, the SYSTEM account SA is used and the results are shown in figure.
Align=baseline border=0>
(3) on the "Data Source" page, select the SQL
Server name or IP address, and select the database, as shown in the figure.
Align=baseline
Border=0>
(4) on the Settings page, select Allow URL query, allow template query, allow XPath, and allow post, respectively, as shown in the figure.
Align=baseline border=0>
(5) in the Virtual
Names page, define the template, schema, and DBObject, respectively, and specify the actual hard drive path, as shown in the figure.
Align=baseline border=0>
Then, identify and close the window. Results.
Align=baseline width=500
Border=0>
http://www.bkjia.com/PHPjc/631161.html www.bkjia.com true http://www.bkjia.com/PHPjc/631161.html techarticle one of the new features of Microsoft SQL Server 2000 is the support for XML, so that users can access the SQL Server2000 database with XML capabilities directly via HTTP. The implementation method is described below. System ...