XML and the SQL 2000 Server, Part 2
(Page 1 of 7 )
In this second article in a series, the basics involved in XML to SQL 2000 Server over HTTP are explained.
In Part 1, the basic elements needed for two-way data exchange between a SQL 2000 Server and XML were discussed. Also given was a step-by-step guide to creating a SQL 2000 Server specific virtual root, which acts as a secure hub for sending HTTP requests to the server. This enhancement effectively substitutes custom methods of querying SQL databases by a simplified, secure method.
The results of such querying can be transformed into presentable data rendered by XSLT style sheets. Virtual directories in the SQL 2000 Server specific virtual root function as safe havens for the documents to be stored. In this tutorial I attempt to elucidate the basics involved in XML to SQL 2000 Server Over HTTP.
Virtual Directory Details for this Tutorial The SQL 2000 Server is running on Windows XP Professional OS with Internet Information Services 5.1 and IE 6.0. As described in Part 1, a SQL 2000 server specific virtual directory is set up with files stored in the local file system as shown. If the virtual directory is configured, the MMC with the virtual directory can be opened by going to All Programs->Microsfot SQL Server-> Configue XML Support for IIS and minimizing the window. When you make changes to the files, it may be advisable to refresh the default website and clicking on "Refresh" from the drop down menu.
The default website (for this virtual directory) has the following settings:
- Virtual Directory Name: PubsVirtual [folder C:\XMLSQL2k]
- SQL Server: (local)-XPHTEK
- Database Name: pubs
- Security: Windows Integrated Authentication
- Access: URL, Template, XPATH
In this tutorial the focus will be on URL Queries and Template files.
Next: Mapping Virtual Objects >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
