Skip to content

Commit 9c9d8d9

Browse files
craigg-msftcraigg-msft
committed
tocs breadcrumbs3
1 parent 4620048 commit 9c9d8d9

24 files changed

Lines changed: 220 additions & 171 deletions

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

Lines changed: 18 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,21 @@
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
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.prod: "sql-non-specified"
9+
ms.topic: "article"
10+
helpviewer_keywords:
11+
- "ADO, what's new"
12+
ms.assetid: 667673f2-3151-432b-894a-3fc60b704ea4
13+
caps.latest.revision: 13
14+
author: "MightyPen"
15+
ms.author: "annemill"
16+
manager: "sonalm"
17+
---
18+
# ADO History
1819
This topic lists the new features introduced by each release of ADO, ADO MD, and ADOX.
1920

2021
## ADO 6.0

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

Lines changed: 18 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -5,30 +5,31 @@ ms.date: "01/19/2017"
55
ms.reviewer: ""
66
ms.suite: ""
77
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
89
ms.topic: "article"
910
helpviewer_keywords:
1011
- "ADO, programming"
1112
ms.assetid: c5b3a134-de22-4e9c-9489-9a1cc7a5dcfa
1213
caps.latest.revision: 14
1314
author: "MightyPen"
14-
ms.author: "annemill"
15+
ms.author: "MightyPen"
1516
manager: "sonalm"
1617
---
1718
# 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-
19+
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.
20+
21+
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.
22+
23+
This section contains the following topics.
24+
25+
- [ADO History](../../ado/guide/ado-history.md)
26+
27+
- [Prerequisites for Using the ADO Documentation](../../ado/guide/prerequisites-for-using-the-ado-documentation.md)
28+
29+
- [Referencing the ADO Libraries](../../ado/guide/referencing-the-ado-libraries.md)
30+
31+
- [ADO Task Table](../../ado/guide/ado-task-table.md)
32+
33+
- [ADO Technology Table](../../ado/guide/ado-technology-table.md)
34+
3435
- [ADO Security Design Issues](../../ado/guide/ado-security-design-issues.md)

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

Lines changed: 15 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -4,6 +4,7 @@ ms.custom: ""
44
ms.date: "01/19/2017"
55
ms.reviewer: ""
66
ms.suite: ""
7+
ms.prod: "sql-non-specified"
78
ms.tgt_pltfrm: ""
89
ms.topic: "article"
910
helpviewer_keywords:
@@ -15,18 +16,18 @@ ms.author: "annemill"
1516
manager: "sonalm"
1617
---
1718
# 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-
19+
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.
20+
21+
This section contains the following topics.
22+
23+
- [Introduction](../../ado/guide/ado-introduction.md)
24+
25+
- [ActiveX Data Objects (ADO)](../../ado/guide/data/activex-data-objects-ado.md)
26+
27+
- [Remote Data Services (RDS)](../../ado/guide/remote-data-service/remote-data-service-rds.md)
28+
29+
- [ADO (Multidimensional) (ADO MD)](../../ado/guide/multidimensional/ado-multidimensional-ado-md.md)
30+
31+
- [ADO Extensions for Data Definition Language and Security (ADOX)](../../ado/guide/extensions/ado-extensions-for-data-definition-language-and-security-adox.md)
32+
3233
- [Appendixes](../../ado/guide/appendixes/ado-appendixes.md)

‎docs/ado/guide/ado-security-design-issues.md‎

Lines changed: 18 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,21 @@
1-
---
2-
title: "ADO Security Design Issues | 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, security"
11-
ms.assetid: 86b83a38-efdf-4831-a6d5-7e470d517d1c
12-
caps.latest.revision: 18
13-
author: "MightyPen"
14-
ms.author: "annemill"
15-
manager: "sonalm"
16-
---
17-
# ADO Security Design Issues
1+
---
2+
title: "ADO Security Design Issues | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
9+
ms.topic: "article"
10+
helpviewer_keywords:
11+
- "ADO, security"
12+
ms.assetid: 86b83a38-efdf-4831-a6d5-7e470d517d1c
13+
caps.latest.revision: 18
14+
author: "MightyPen"
15+
ms.author: "annemill"
16+
manager: "sonalm"
17+
---
18+
# ADO Security Design Issues
1819
The following sections describe security design features in ActiveX Data Objects (ADO) 2.8 and later. These changes were made in ADO 2.8 to improve security. ADO 6.0, which is included in Windows DAC 6.0 in Windows Vista, is functionally equivalent to ADO 2.8, which was included in MDAC 2.8 in Windows XP and Windows Server 2003. This topic provides information about how to best secure your applications in ADO 2.8 or later.
1920

2021
> [!IMPORTANT]

‎docs/ado/guide/ado-task-table.md‎

Lines changed: 19 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -1,21 +1,22 @@
1-
---
2-
title: "ADO Task Table | 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-
- "tasks [ADO]"
11-
- "ADO, tasks"
12-
ms.assetid: 2fad33fb-c858-4dcb-98dc-3dfd0e555055
13-
caps.latest.revision: 9
14-
author: "MightyPen"
15-
ms.author: "annemill"
16-
manager: "sonalm"
17-
---
18-
# ADO Task Table
1+
---
2+
title: "ADO Task Table | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
9+
ms.topic: "article"
10+
helpviewer_keywords:
11+
- "tasks [ADO]"
12+
- "ADO, tasks"
13+
ms.assetid: 2fad33fb-c858-4dcb-98dc-3dfd0e555055
14+
caps.latest.revision: 9
15+
author: "MightyPen"
16+
ms.author: "annemill"
17+
manager: "sonalm"
18+
---
19+
# ADO Task Table
1920
The following table lists programming tasks contained in the *ADO Programmer's Guide* and provides references for each task. These references can be textual descriptions or code examples in which you can find information about the ADO feature that performs the task.
2021

2122
|ADO Task|References|

‎docs/ado/guide/ado-technology-table.md‎

Lines changed: 18 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,21 @@
1-
---
2-
title: "ADO Technology Table | 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, technologies"
11-
ms.assetid: 38c8ad3c-d6f1-40f6-a394-bbba6ed861e5
12-
caps.latest.revision: 15
13-
author: "MightyPen"
14-
ms.author: "annemill"
15-
manager: "sonalm"
16-
---
17-
# ADO Technology Table
1+
---
2+
title: "ADO Technology Table | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
9+
ms.topic: "article"
10+
helpviewer_keywords:
11+
- "ADO, technologies"
12+
ms.assetid: 38c8ad3c-d6f1-40f6-a394-bbba6ed861e5
13+
caps.latest.revision: 15
14+
author: "MightyPen"
15+
ms.author: "annemill"
16+
manager: "sonalm"
17+
---
18+
# ADO Technology Table
1819
The following table lists the Microsoft products, tools, and technologies discussed in the ADO Programmer's Guide. It provides links, wherever possible, to relevant topics in the guide.
1920

2021
|Microsoft Product or Technology|References|

‎docs/ado/guide/prerequisites-for-using-the-ado-documentation.md‎

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -5,6 +5,7 @@ ms.date: "01/19/2017"
55
ms.reviewer: ""
66
ms.suite: ""
77
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
89
ms.topic: "article"
910
helpviewer_keywords:
1011
- "ADO, prerequisites"
@@ -15,8 +16,8 @@ ms.author: "annemill"
1516
manager: "sonalm"
1617
---
1718
# Prerequisites for Using the ADO Documentation
18-
To use this documentation, you should have, at a minimum, some experience developing applications with Microsoft Visual Basic, because most of the examples in the guide are written in this language. There are also some examples written in Microsoft Visual C++, Java, Visual Basic Scripting Edition (VBScript), and Microsoft JScript.
19-
20-
Because ADO is used for accessing data from a variety of sources, you will also need some understanding of relational database management systems and online analytical processing (OLAP), and basic familiarity with the Internet and Internet protocols.
21-
19+
To use this documentation, you should have, at a minimum, some experience developing applications with Microsoft Visual Basic, because most of the examples in the guide are written in this language. There are also some examples written in Microsoft Visual C++, Java, Visual Basic Scripting Edition (VBScript), and Microsoft JScript.
20+
21+
Because ADO is used for accessing data from a variety of sources, you will also need some understanding of relational database management systems and online analytical processing (OLAP), and basic familiarity with the Internet and Internet protocols.
22+
2223
Because ADO and the related OLE DB technology are based on the Microsoft Component Object Model (COM), knowledge of COM will help you to better understand advanced concepts in ADO.

‎docs/ado/guide/referencing-the-ado-libraries-in-a-visual-basic-6-application.md‎

Lines changed: 22 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1,24 +1,25 @@
1-
---
2-
title: "Referencing the ADO Libraries In a Visual Basic 6 Application | 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-
dev_langs:
10-
- "VB"
11-
helpviewer_keywords:
12-
- "libraries [ADO]"
13-
- "referencing libraries in a Visual Basic application[ADO]"
14-
- "ADO, libraries"
15-
ms.assetid: cfd37a82-aad2-41cd-8d13-1566c43d95f0
16-
caps.latest.revision: 12
17-
author: "MightyPen"
18-
ms.author: "annemill"
19-
manager: "sonalm"
20-
---
21-
# Referencing the ADO Libraries In a Visual Basic 6 Application
1+
---
2+
title: "Referencing the ADO Libraries In a Visual Basic 6 Application | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "01/19/2017"
5+
ms.reviewer: ""
6+
ms.suite: ""
7+
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
9+
ms.topic: "article"
10+
dev_langs:
11+
- "VB"
12+
helpviewer_keywords:
13+
- "libraries [ADO]"
14+
- "referencing libraries in a Visual Basic application[ADO]"
15+
- "ADO, libraries"
16+
ms.assetid: cfd37a82-aad2-41cd-8d13-1566c43d95f0
17+
caps.latest.revision: 12
18+
author: "MightyPen"
19+
ms.author: "annemill"
20+
manager: "sonalm"
21+
---
22+
# Referencing the ADO Libraries In a Visual Basic 6 Application
2223
To import the ADO libraries into a Microsoft Visual Basic 6 application, you must set a reference in the Visual Basic project.
2324

2425
### To set a reference to the ADO libraries in a Visual Basic project

‎docs/ado/guide/referencing-the-ado-libraries-in-a-visual-c-application.md‎

Lines changed: 21 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -4,6 +4,7 @@ ms.custom: ""
44
ms.date: "01/19/2017"
55
ms.reviewer: ""
66
ms.suite: ""
7+
ms.prod: "sql-non-specified"
78
ms.tgt_pltfrm: ""
89
ms.topic: "article"
910
dev_langs:
@@ -19,24 +20,24 @@ ms.author: "annemill"
1920
manager: "sonalm"
2021
---
2122
# Referencing the ADO Libraries In a Visual C++ Application
22-
To use the latest version of ADO in a Visual C++ application, use the following `#import` directive:
23-
24-
```
25-
#import "msado15.dll" \
26-
no_namespace rename("EOF", "EndOfFile")
27-
```
28-
29-
To use ADO MD or ADOX, you must import *msadomd.dll* or *msadox.dll*, by using the syntax above.
30-
31-
## Backward Compatibility
32-
To use any earlier version of ADO, replace *msado15.dll* above with one of the following type libraries.
33-
34-
- *msado27.tlb*, ADO 2.7 Type Library
35-
36-
- *msado26.tlb*, ADO 2.6 Type Library
37-
38-
- *msado25.tlb*, ADO 2.5 Type Library
39-
40-
- *msado21.tlb*, ADO 2.1 Type Library
41-
23+
To use the latest version of ADO in a Visual C++ application, use the following `#import` directive:
24+
25+
```
26+
#import "msado15.dll" \
27+
no_namespace rename("EOF", "EndOfFile")
28+
```
29+
30+
To use ADO MD or ADOX, you must import *msadomd.dll* or *msadox.dll*, by using the syntax above.
31+
32+
## Backward Compatibility
33+
To use any earlier version of ADO, replace *msado15.dll* above with one of the following type libraries.
34+
35+
- *msado27.tlb*, ADO 2.7 Type Library
36+
37+
- *msado26.tlb*, ADO 2.6 Type Library
38+
39+
- *msado25.tlb*, ADO 2.5 Type Library
40+
41+
- *msado21.tlb*, ADO 2.1 Type Library
42+
4243
- *msado20.tlb*, ADO 2.0 Type Library

‎docs/ado/guide/referencing-the-ado-libraries.md‎

Lines changed: 7 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -5,6 +5,7 @@ ms.date: "01/19/2017"
55
ms.reviewer: ""
66
ms.suite: ""
77
ms.tgt_pltfrm: ""
8+
ms.prod: "sql-non-specified"
89
ms.topic: "article"
910
helpviewer_keywords:
1011
- "libraries [ADO]"
@@ -17,10 +18,10 @@ ms.author: "annemill"
1718
manager: "sonalm"
1819
---
1920
# Referencing the ADO Libraries
20-
The latest version of ADO is packaged as *msado15.dll*. The latest versions of ADO MD and ADOX are packaged as *msadom.dll* and *msadox.dll*, respectively. These libraries are installed by default in *$installDir*, where *$installDir* stands for the path of the directory in which the ADO library has been installed on your computer. To use the ADO libraries in your application, you must reference them explicitly in the application project.
21-
22-
The following are steps that you can take to reference the ADO libraries:
23-
24-
- [In a Visual Basic Application](../../ado/guide/referencing-the-ado-libraries-in-a-visual-basic-6-application.md)
25-
21+
The latest version of ADO is packaged as *msado15.dll*. The latest versions of ADO MD and ADOX are packaged as *msadom.dll* and *msadox.dll*, respectively. These libraries are installed by default in *$installDir*, where *$installDir* stands for the path of the directory in which the ADO library has been installed on your computer. To use the ADO libraries in your application, you must reference them explicitly in the application project.
22+
23+
The following are steps that you can take to reference the ADO libraries:
24+
25+
- [In a Visual Basic Application](../../ado/guide/referencing-the-ado-libraries-in-a-visual-basic-6-application.md)
26+
2627
- [In a Visual C++ Application](../../ado/guide/referencing-the-ado-libraries-in-a-visual-c-application.md)

0 commit comments

Comments
 (0)