adoRS.Open "file:/// C:\\Directory\\portfolio.xml", adoConn

<price>$70.00</price>

<info>

<companyname>Microsoft Corporation</companyname>

</info>

</stock>

<stock>

<price>$107.00</price>

<info>

<companyname>Apple Computer, Inc.</companyname>

</info>

</stock>

<stock>

<price>$50.00</price>

<info>

<companyname>Dell Corporation</companyname>

</info>

</stock>

<stock>

<price>$115.00</price>

<info>

<companyname>Intel Corporation</companyname>

</info>

</stock>

</portfolio>

Set adoChildRS = ADODB.Recordset

adoConn.Open "Provider=MSDAOSP; Data Source=MSXML2.DSOControl.2.6;"

Dim iLevel As Integer

iLevel = 0

For example, the following code sample shows how to open a **Recordset** on the Readme25.txt file of the Winnt/system32 directory:

```

```

The absolute URL in the connection string specifies the server (`YourServer`) and the path (`Winnt`). This URL also defines the context.

As another example, the following code will open a **Recordset** on the contents of the `Winnt` directory:

```

```

|**3724**|**adErrCantConvertvalue**|Data value cannot be converted for reasons other than sign mismatch or data overflow. For example, conversion would have truncated data.|

|**3725**|**adErrCantCreate**|Data value cannot be set or retrieved because the field data type was unknown, or the provider had insufficient resources to perform the operation.|

|**3726**|**adErrColumnNotOnThisRow**|Record does not contain this field. An incorrect field name was specified or a field not in the **Fields** collection of the current record was referenced.|

|**3728**|**adErrTreePermissionDenied**|Permissions are insufficient to access tree or subtree. The user named in the connection string does not have the appropriate permissions.|

|**3729**|**adErrInvalidURL**|URL contains invalid characters. Make sure the URL is typed correctly. The URL follows the scheme registered to the current provider (for example, Internet Publishing Provider is registered for http).|

|**3730**|**adErrResourceLocked**|Object represented by the specified URL is locked by one or more other processes. Wait until the process has finished and attempt the operation again. The object you are trying to access has been locked by another user or by another process in your application. This is most likely to arise in a multi-user environment.|

```

|rs|Refers to the namespace containing elements and attributes specific to ADO Recordset properties and attributes.|

|z|Refers to the schema of the current rowset.|

You can save a hierarchical **Recordset** to a file in either ADTG or XML format by calling the [Save](../../../ado/reference/ado-api/save-method.md) method. However, two limitations apply when saving hierarchical **Recordset**s in XML format: You cannot save in XML if the hierarchical **Recordset** contains pending updates, and you cannot save a parameterized hierarchical **Recordset**.

[Data Shaping Example](../../../ado/guide/data/data-shaping-example.md)

Similarly, because there is no alias defined for `CompanyName` in the previous example, `CompanyName` must be used consistently throughout the document.

```

Universal Data Access provides a *component architecture* that allows individual, specialized components to implement discrete sets of database functionality, or "services," on top of less capable stores. Thus, rather than forcing each data store to provide its own implementation of extended functionality or forcing generic applications to implement database functionality internally, service components provide a common implementation that any application can use when accessing any data store. The fact that some functionality is implemented natively by the data store and some through generic components is transparent to the application.

For more information about service and data providers, see [Appendix A: Providers](../../../ado/guide/appendixes/appendix-a-providers.md).

You can access the **Recordset** components of the shaped **Recordset** programmatically or through an appropriate visual control.

For information about navigating a hierarchical **Recordset**, see [Accessing Rows in a Hierarchical Recordset](../../../ado/guide/data/accessing-rows-in-a-hierarchical-recordset.md).