Opening a Record Object Referencing an Open Recordset Object (Page 1 of 4 )
As the title suggests, this tutorial explains how to open a record object with the help of previously open recordset object. In ADO, the two are closely related. Keep reading to learn more.
Introduction
In the previous tutorial, Using ADO’s Record Object With URLs, it was shown in considerable detail how a record object may be leveraged to access files and folders on a web site. This tutorial shows how a record object may be opened by referencing an already open recordset object. As you may see in the following picture, the record and recordset objects are interrelated in the ADO Model.
Opening a record object
In order to use the record and recordset objects you need the OLEDB providers. In fact, since the Record object has to use an already open recordset object, the Recordset object has to be opened first. The record object represents a single row in the open recordset object. The record object's strength is its ability to navigate hierarchical structures of file and folders, while the recordset must use an OLE DB provider suitable for this purpose.
The most appropriate OLEDB provider is the OLEDB Provider for Internet Publishing (MSDAIPP). MSDAIPP stands for Microsoft Data Access Component Internet Publishing Provider. The file location is C: Program Files Common Files System OleDB. If you have Microsoft Office 2000 and above, or your operating system is Windows 2000 or Office XP Professional, you should have the file in your system as shown here.
The MSDAIPP can access folders and files on web servers if the following items are supported:
- FrontPage Server Extensions
- Web Extender Client
- Web Distributed Authoring and Versioning
(WebDAV or HTTP-DAV) protocol extension for HTTP
In order to use the above provider, you need to provide a valid URL address for the file you want to open. Here we will be using some intranet (local web server) virtual folders as shown in the following pictures.
This picture shows the virtual site that is used in opening the recordset.
Next: Opening a Recordset by Providing an URL >>
More Database Articles
More By Jayaram Krishnaswamy
/ 3 
