Skip to content

Commit f2cfd27

Browse files
craigg-msftcraigg-msft
committed
Migration: migration from Caps to OP
1 parent fe158ff commit f2cfd27

4,418 files changed

Lines changed: 296984 additions & 0 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/TOC.md‎

Lines changed: 52 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,52 @@
1+
# [ado](ado\TOC.md)
2+
# [guide](ado\guide\TOC.md)
3+
# [appendixes](ado\guide\appendixes\TOC.md)
4+
# [data](ado\guide\data\TOC.md)
5+
# [extensions](ado\guide\extensions\TOC.md)
6+
# [multidimensional](ado\guide\multidimensional\TOC.md)
7+
# [remote-data-service](ado\guide\remote-data-service\TOC.md)
8+
# [reference](ado\reference\TOC.md)
9+
# [ado-api](ado\reference\ado-api\TOC.md)
10+
# [ado-md-api](ado\reference\ado-md-api\TOC.md)
11+
# [adox-api](ado\reference\adox-api\TOC.md)
12+
# [rds-api](ado\reference\rds-api\TOC.md)
13+
# [connect](connect\TOC.md)
14+
# [ado-net](connect\ado-net\TOC.md)
15+
# [jdbc](connect\jdbc\TOC.md)
16+
# [code-samples](connect\jdbc\code-samples\TOC.md)
17+
# [reference](connect\jdbc\reference\TOC.md)
18+
# [node-js](connect\node-js\TOC.md)
19+
# [odbc](connect\odbc\TOC.md)
20+
# [linux](connect\odbc\linux\TOC.md)
21+
# [windows](connect\odbc\windows\TOC.md)
22+
# [php](connect\php\TOC.md)
23+
# [python](connect\python\TOC.md)
24+
# [pymssql](connect\python\pymssql\TOC.md)
25+
# [pyodbc](connect\python\pyodbc\TOC.md)
26+
# [ruby](connect\ruby\TOC.md)
27+
# [odbc](odbc\TOC.md)
28+
# [admin](odbc\admin\TOC.md)
29+
# [microsoft](odbc\microsoft\TOC.md)
30+
# [reference](odbc\reference\TOC.md)
31+
# [appendixes](odbc\reference\appendixes\TOC.md)
32+
# [develop-app](odbc\reference\develop-app\TOC.md)
33+
# [develop-driver](odbc\reference\develop-driver\TOC.md)
34+
# [install](odbc\reference\install\TOC.md)
35+
# [syntax](odbc\reference\syntax\TOC.md)
36+
# [sample](sample\TOC.md)
37+
# [world-wide-importers](sample\world-wide-importers\TOC.md)
38+
# [ssdt](ssdt\TOC.md)
39+
# [ssma](ssma\TOC.md)
40+
# [access](ssma\access\TOC.md)
41+
# [db2](ssma\db2\TOC.md)
42+
# [mysql](ssma\mysql\TOC.md)
43+
# [oracle](ssma\oracle\TOC.md)
44+
# [sybase](ssma\sybase\TOC.md)
45+
# [ssms](ssms\TOC.md)
46+
# [agent](ssms\agent\TOC.md)
47+
# [f1-help](ssms\f1-help\TOC.md)
48+
# [menu-help](ssms\menu-help\TOC.md)
49+
# [object](ssms\object\TOC.md)
50+
# [solution](ssms\solution\TOC.md)
51+
# [template](ssms\template\TOC.md)
52+
# [visual-db-tools](ssms\visual-db-tools\TOC.md)

‎docs/ado/TOC.md‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
# [ADO Glossary](ado-glossary.md)
2+
# [Microsoft ActiveX Data Objects (ADO)](microsoft-activex-data-objects-ado.md)

‎docs/ado/ado-glossary.md‎

Lines changed: 290 additions & 0 deletions
Large diffs are not rendered by default.

‎docs/ado/guide/TOC.md‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
# [ADO Programmer's Guide](ado-programmer-s-guide.md)
2+
# [Referencing the ADO Libraries In a Visual C++ Application](referencing-the-ado-libraries-in-a-visual-c-application.md)
3+
# [Referencing the ADO Libraries In a Visual Basic 6 Application](referencing-the-ado-libraries-in-a-visual-basic-6-application.md)
4+
# [ADO Introduction](ado-introduction.md)
5+
# [ADO Security Design Issues](ado-security-design-issues.md)
6+
# [ADO History](ado-history.md)
7+
# [Referencing the ADO Libraries](referencing-the-ado-libraries.md)
8+
# [Prerequisites for Using the ADO Documentation](prerequisites-for-using-the-ado-documentation.md)
9+
# [ADO Technology Table](ado-technology-table.md)
10+
# [ADO Task Table](ado-task-table.md)

‎docs/ado/guide/ado-history.md‎

Lines changed: 78 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,78 @@
1+
---
2+
title: "ADO History | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.topic: "article"
9+
helpviewer_keywords:
10+
- "ADO, what's new"
11+
ms.assetid: 667673f2-3151-432b-894a-3fc60b704ea4
12+
caps.latest.revision: 13
13+
author: "MightyPen"
14+
ms.author: "annemill"
15+
manager: "sonalm"
16+
---
17+
# ADO History
18+
This topic lists the new features introduced by each release of ADO, ADO MD, and ADOX.
19+
20+
## ADO 6.0
21+
ADO 6.0 is included in Windows Vista, as a part of the Windows Data Access Components (Windows DAC) 6.0. ADO 6.0 is functionally equivalent to ADO 2.8.
22+
23+
## ADO 2.8
24+
ADO 2.8 was included in Windows XP and Windows Server 2003, as part of the Microsoft Data Access Components (MDAC) 2.8. A redistributable version of MDAC 2.8 is also available; note that this redistributable version should only be installed on Windows 2000. ADO 2.8 addresses several security-related concerns:
25+
26+
*Hard drive access is not allowed outside a trusted zone.*
27+
In cross-domain scripting involving nontrusted sites, the following operations are disabled: **Stream.SaveToFile**, **Stream.LoadFromFile**, **Recordset.Save**, and **Recordset.Open**, used in conjunction with the **adCmdFile** flag or with the Microsoft OLE DB Persistence Provider (MSPersist).
28+
29+
**Recordset.Open** *,* **Recordset.Save** *,* **Stream.SaveToFile** *, and* **Stream.LoadFromFile** *operate on physical files only.*
30+
These methods now verify that file handles point to physical files only.
31+
32+
**Recordset.ActiveCommand** *returns an error when invoked from an HTML/ASP page.*
33+
This prevents the **Command** object from being misused.
34+
35+
*The number of* **Recordsets** *returned by a nested* **Shape** *command has an upper bound.*
36+
A nested shape command now returns a maximum of 512 **Recordsets**. This means that a **Shape** command can no longer be nested at any depth. Instead, the maximum level depth is 512, if each command results in a single (child) **Recordset**. If, at any level, a **Shape** command returns multiple **Recordsets**, the maximum level of depth will be less than 512.
37+
38+
## ADO 2.7
39+
*64-bit platform support*
40+
ADO 2.7 introduces support for 64-bit processors.
41+
42+
## ADO 2.6
43+
**CubDef.GetSchemaObject** *Method*
44+
Starting with ADO 2.6, ADO MD objects can be retrieved using unique names, as specified by the [UniqueName property (ADO MD)](../../ado/reference/ado-md-api/uniquename-property-ado-md.md). 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 (ADO MD)](../../ado/reference/ado-md-api/getschemaobject-method-ado-md.md).
45+
46+
*Command streams*
47+
The **Command** object supports commands in stream format as an alternative to using the **CommandText** property. The [CommandStream property (ADO)](../../ado/reference/ado-api/commandstream-property-ado.md) can be used to specify XML Templates or updategrams as the **Command** input with the Microsoft OLE DB Provider for SQL Server.
48+
49+
**Dialect** *property*
50+
[Dialect](../../ado/reference/ado-api/dialect-property.md) is a new property that defines the syntax and general rules that the provider uses to parse the string or stream.
51+
52+
**Command.Execute** *method*
53+
The [Execute method](../../ado/reference/ado-api/execute-method-ado-command.md) of the ADO **Command** object has been enhanced to use streams for input and output.
54+
55+
*Field statusvalues*
56+
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)](../../ado/reference/ado-api/status-property-ado-field.md).
57+
58+
**NamedParameters** *property*
59+
[NamedParameters](../../ado/reference/ado-api/namedparameters-property-ado.md) is a new property of the **Command** object that indicates that the provider should use named parameters.
60+
61+
*Resultsets in streams*
62+
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](../../ado/guide/data/retrieving-resultsets-into-streams.md).
63+
64+
*Single row resultset*
65+
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)](../../ado/reference/ado-api/open-method-ado-record.md).
66+
67+
## ADO 2.5
68+
**Record** *object*
69+
ADO 2.5 introduces the **Record** object to represent and manage a row from a **Recordset** or a data provider, or an object encapsulating a semi-structured data, such as a file or directory.
70+
71+
**Stream** *object*
72+
ADO 2.5 also introduces the **Stream** object to represent a stream of binary or text data.
73+
74+
*URL binding*
75+
ADO 2.5 introduces the use of a URL, as an alternative to a connection string and command text, to name data store objects. A URL can be used with the existing **Connection** and **Recordset** objects, as well as with the new **Record** and **Stream** objects.
76+
77+
*Data providers supporting URL binding*
78+
ADO 2.5 supports OLE DB providers that recognize the URL schemes. This includes OLE DB Provider for Internet Publishing, which accesses the Windows 2000 file system and recognizes the existing HTTP scheme.

‎docs/ado/guide/ado-introduction.md‎

Lines changed: 34 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,34 @@
1+
---
2+
title: "ADO Introduction | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.topic: "article"
9+
helpviewer_keywords:
10+
- "ADO, programming"
11+
ms.assetid: c5b3a134-de22-4e9c-9489-9a1cc7a5dcfa
12+
caps.latest.revision: 14
13+
author: "MightyPen"
14+
ms.author: "annemill"
15+
manager: "sonalm"
16+
---
17+
# ADO Introduction
18+
ActiveX Data Objects (ADO) is a high-level, easy-to-use interface to OLE DB. OLE DB is a low-level, high-performance interface to a variety of data stores. Both ADO and OLE DB can work with relational (tabular) and nonrelational (hierarchical or stream) data.
19+
20+
ADO provides a layer of abstraction between your client or middle-tier application and the low-level OLE DB interfaces. ADO uses a small set of Automation objects to provide a simple and efficient interface to OLE DB. This interface makes ADO a good choice for developers in higher level languages, such as Visual Basic and VBScript, who want to access data without having to learn the intricacies of COM and OLE DB.
21+
22+
This section contains the following topics.
23+
24+
- [ADO History](../../ado/guide/ado-history.md)
25+
26+
- [Prerequisites for Using the ADO Documentation](../../ado/guide/prerequisites-for-using-the-ado-documentation.md)
27+
28+
- [Referencing the ADO Libraries](../../ado/guide/referencing-the-ado-libraries.md)
29+
30+
- [ADO Task Table](../../ado/guide/ado-task-table.md)
31+
32+
- [ADO Technology Table](../../ado/guide/ado-technology-table.md)
33+
34+
- [ADO Security Design Issues](../../ado/guide/ado-security-design-issues.md)

‎docs/ado/guide/ado-programmer-s-guide.md‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
---
2+
title: "ADO Programmer's Guide | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.topic: "article"
9+
helpviewer_keywords:
10+
- "ADO, programmer's guide"
11+
ms.assetid: e3c50eee-964a-4abd-810d-1bd51978e814
12+
caps.latest.revision: 12
13+
author: "MightyPen"
14+
ms.author: "annemill"
15+
manager: "sonalm"
16+
---
17+
# ADO Programmer's Guide
18+
This documentation provides an overview of how to use ADO objects to work with data from various data sources. First, the introduction summarizes the new features and the requirement for installing, using, and redistributing the ADO component. The next sections discuss the use of the various types of ADO objects. Finally, the appendixes discuss various Microsoft-supplied data and service providers, error messages, and tips about how to use ADO in several programming languages, in addition to samples and a glossary.
19+
20+
This section contains the following topics.
21+
22+
- [Introduction](../../ado/guide/ado-introduction.md)
23+
24+
- [ActiveX Data Objects (ADO)](../../ado/guide/data/activex-data-objects-ado.md)
25+
26+
- [Remote Data Services (RDS)](../../ado/guide/remote-data-service/remote-data-service-rds.md)
27+
28+
- [ADO (Multidimensional) (ADO MD)](../../ado/guide/multidimensional/ado-multidimensional-ado-md.md)
29+
30+
- [ADO Extensions for Data Definition Language and Security (ADOX)](../../ado/guide/extensions/ado-extensions-for-data-definition-language-and-security-adox.md)
31+
32+
- [Appendixes](../../ado/guide/appendixes/ado-appendixes.md)

0 commit comments

Comments
 (0)