Virtual Directories


Before we can accomplish anything productive, it is necessary to create a virtual directory from which to work. This directory is also known as the virtual root and must be registered on a server running IIS. (The terms virtual root and virtual directory are used synonymously.) TheVirtual Directory Management Utility, which creates an association between the virtual root and a Microsoft SQL Server instance, is the tool we'll use.

When you install SQL Server 2000 on your application server, it installs the Configure SQL XML Support in IIS option on the SQL Server menu. This option gives you the capability to create a virtual root for SQL Server 2000. After you create this root, you can configure virtual names and directories used to identify the location of your templates, schemas, and objects through this menu option as well. All current Web servers have the capability to implement virtual directories. These configuration steps only configure SQL Server to point to the virtual root and directories contained in IIS.

If these configuration steps are not completed, then the examples later in this chapter will not work.

You can create the virtual directory using these methods :

  • Graphically, with the IIS Virtual Directory Management for SQL Server Utility

  • Programmatically, using the IIS Virtual Directory Management for SQL Server Object Model

In this chapter, we cover the IIS Virtual Directory Management Utility, which is installed as part of the SQL Server general installation. Then, we'll move on to the Object Model.



XML and SQL Server 2000
XML and SQL Server 2000
ISBN: 0735711127
EAN: 2147483647
Year: 2005
Pages: 104
Authors: John Griffin

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net