| ADO Programmer's Guide |  |
| ADO Programmer's Guide | |
The following new features and enhanced documentation are included in the ADO 2.6 release. This list covers ADO, ADO MD, and ADOX.
| New Feature | Description |
|---|---|
| ADO MD CubeDef.GetSchemaObject Method | ADO MD objects can now be retrieved using unique names, as specified by the UniqueName property. The names of parent objects do not need to be known, and parent collections do not need to be populated to retrieve a schema object. See GetSchemaObject Method. |
| ADOX Group and User Properties | ADOX Group and User objects now surface a Properties collection, which can be populated with provider-specific properties. Specifically, the OLEDB:Trustee PIN property can be specified. |
| Command Streams | The Command object supports commands in stream format as an alternative to using the CommandText property. The CommandStream property can be used to specify XML Templates or updategrams as the Command input with the Microsoft OLE DB Provider for SQL Server. |
| Dialect Property | Dialect is a new property that defines the syntax and general rules that the provider uses to parse the string or stream. |
| Execute Method (ADO Command) | The Execute method of the Command object has been enhanced to use streams for input and output. |
| Field Status Values | If the user encounters a DB_E_ERRORSOCCURRED error when modifying a Field of a Recordset, ADO will now fill the Field.Status property with the appropriate status information so that the user will have more information about what went wrong. See Status Property (ADO Field). |
| NamedParameters Property | NamedParameters is a new property of the Command object that indicates that the provider should use named parameters. |
| Resultsets in Streams | ADO can return resultsets from a data source in a Stream, rather than a Recordset object. Using the latest version of the Microsoft OLE DB Provider for SQL Server, you can get XML results from the provider by executing a "For XML" query. A Stream that receives the resultset can be opened with a "For XML" command as the source. See Retrieving Resultsets Into Streams. |
| Single Row Resultset | The ADO Record object can now be opened on a command string or Command object that returns one row of data from the provider. This results in improved performance with MDAC 2.6 providers. See Open Method (ADO Record). |
Conceptual and tutorial topics for ADO have been written or reorganized into a comprehensive ADO developer's guide.
The examples have been expanded to contain additional examples written in VBScript and JScript.
The ADO samples have been revised and new samples have been added.