The SQLVDir object is a virtual directory object obtained by calling the Item method (or by calling the AddVirtualDirectory method if you are creating a new virtual directory).
The SQLVDir object supports the following properties. You can get and set values for all of these properties except the Password property (for which you can set, but cannot get, the value).
Is the name of the virtual directory.
Is the full physical path to the directory associated with the virtual directory.
Is the name of the server running Microsoft® SQL Server™ 2000, which is the data source for the virtual directory.
Is the default database used in queries against this virtual directory.
Is the user login that is used to connect to the data source.
Is the user password that is used to connect to the data source.
Is the login authentication method that is used with the virtual directory, such as SQL Authentication or Windows Integrated Authentication. You can specify one of these values.
|1||SQL Server login|
|2||Microsoft Windows® anonymous login|
|8||Windows Integrated Authentication|
Caution If you are changing the connection settings (changing server name, database name, user name, password or the security mode), it is recommended that the virtual directory access be disallowed. The virtual directory can be disabled by setting the AllowFlags property to 0.
Provides the type of access allowed through this virtual directory. You can specify one (or a combination) of these values.
Specifies whether Microsoft® Internet Information Services (IIS) is allowed to handle the anonymous password synchronization.
Provides the full path to the Sqlisapi.dll.
Are user-defined settings appended to the OLE DB connection string.
The SQLVDir object also supports this method:
Is the collection of virtual name mappings for the virtual directory.
This example establishes a connection to the first Web site on an IIS server. The first virtual directory object (index 0) on the connected Web site is accessed. The PhysicalPath property of the object is set to C:\inetpub.
Set ObjXML = CreateObject("SQLVDir.SQLVDirControl") ObjXML.Connect "IISServer", "1" Set ObjVDirs = ObjXML.SQLVDirs Set ObjVDir = ObjVDirs.Item(0) ObjVDir.PhysicalPath = "C:\" ObjVDir.PhysicalPath = ObjVDir.PhysicalPath & "inetpub" ... ObjXML.Disconnect