Skip to content

Commit 7c19d9a

Browse files
yukiwongkyyukiwongky
authored
Merge branch 'master' into addmi5
2 parents daa47bb + 07a8e56 commit 7c19d9a

75 files changed

Lines changed: 376 additions & 160 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/connect/oledb/ole-db-errors/errors.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Errors | Microsoft Docs"
33
description: "Errors"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -21,7 +22,9 @@ ms.author: "Pedro.Lopes"
2122
manager: craigg
2223
---
2324
# Errors
24-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
25+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
26+
27+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2528

2629
OLE/COM objects report errors through the HRESULT return code of object member functions. An OLE/COM HRESULT is a bit-packed structure. OLE provides macros that dereference structure members.
2730

‎docs/connect/oledb/ole-db-errors/information-in-error-interfaces.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Information in Error Interfaces | Microsoft Docs"
33
description: "Information in error interfaces"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -22,7 +23,9 @@ ms.author: "Pedro.Lopes"
2223
manager: craigg
2324
---
2425
# Information in Error Interfaces
25-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
26+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
27+
28+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2629

2730
The OLE DB Driver for SQL Server reports some error and status information in the OLE DB-defined error interfaces **IErrorInfo**, **IErrorRecords**, and **ISQLErrorInfo**.
2831

‎docs/connect/oledb/ole-db-errors/retrieving-error-information.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Retrieving Error Information | Microsoft Docs"
33
description: "Retrieving error information using OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -22,7 +23,9 @@ ms.author: "Pedro.Lopes"
2223
manager: craigg
2324
---
2425
# Retrieving Error Information
25-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
26+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
27+
28+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2629

2730
This example obtains information from the various error interfaces exposed by the OLE DB Driver for SQL Server.
2831

‎docs/connect/oledb/ole-db-errors/return-codes.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Return Codes | Microsoft Docs"
33
description: "Return codes"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -27,7 +28,9 @@ ms.author: "Pedro.Lopes"
2728
manager: craigg
2829
---
2930
# Return Codes
30-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
31+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
32+
33+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
3134

3235
At the most basic level, a member function either succeeds or fails. At a somewhat more precise level, a function can succeed, but its success may not be what the application developer intended.
3336

‎docs/connect/oledb/ole-db-errors/sql-server-error-detail.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "SQL Server Error Detail | Microsoft Docs"
33
description: "SQL Server error detail"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -22,7 +23,9 @@ ms.author: "Pedro.Lopes"
2223
manager: craigg
2324
---
2425
# SQL Server Error Detail
25-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
26+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
27+
28+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2629

2730
The OLE DB Driver for SQL Server defines the provider-specific error interface [ISQLServerErrorInfo](http://msdn.microsoft.com/library/a8323b5c-686a-4235-a8d2-bda43617b3a1). The interface returns more detail about a [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] error and is valuable when command execution or rowset operations fail.
2831

‎docs/connect/oledb/ole-db-errors/sql-server-message-results.md‎

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "SQL Server Message Results | Microsoft Docs"
33
description: "SQL Server message results"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-errors"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -19,7 +20,9 @@ ms.author: "Pedro.Lopes"
1920
manager: craigg
2021
---
2122
# SQL Server Message Results
22-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
23+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
24+
25+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2326

2427
The following [!INCLUDE[tsql](../../../includes/tsql-md.md)] statements do not generate OLE DB Driver for SQL Server rowsets or a count of affected rows when executed:
2528

@@ -35,7 +38,7 @@ manager: craigg
3538

3639
These statements either return one or more informational messages or cause [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] to return informational messages in place of rowset or count results. On successful execution, the OLE DB Driver for SQL Server returns S_OK, and the messages are available to the OLE DB Driver for SQL Server consumer.
3740

38-
The OLE DB Driver for SQL Server returns S_OK and has one or more informational messages available following the execution of many [!INCLUDE[tsql](../../../includes/tsql-md.md)] statements or the consumer execution of a OLE DB Driver for SQL Server member function.
41+
The OLE DB Driver for SQL Server returns S_OK and has one or more informational messages available following the execution of many [!INCLUDE[tsql](../../../includes/tsql-md.md)] statements or the consumer execution of an OLE DB Driver for SQL Server member function.
3942

4043
The OLE DB Driver for SQL Server consumer allowing dynamic specification of query text should check error interfaces after every member function execution regardless of the value of the return code, the presence or absence of a returned **IRowset** or **IMultipleResults** interface reference, or a count of affected rows.
4144

‎docs/connect/oledb/ole-db-how-to/bulk-copy-data-using-irowsetfastload-ole-db.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Bulk Copy Data Using IRowsetFastLoad (OLE DB) | Microsoft Docs"
33
description: "Bulk copy data into a SQL Server table Using IRowsetFastLoad interface of OLE DB Driver for SQL Server"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-how-to"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -20,7 +21,9 @@ ms.author: "Pedro.Lopes"
2021
manager: craigg
2122
---
2223
# Bulk Copy Data Using IRowsetFastLoad (OLE DB)
23-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
25+
26+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2427

2528
This sample shows the use of IRowsetFastLoad for bulk copying of records into a table.
2629

‎docs/connect/oledb/ole-db-how-to/change-a-sql-server-authentication-user-password-ole-db.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Change a SQL Server Authentication User Password (OLE DB) | Microsoft Docs"
33
description: "Change a SQL Server authentication user password (OLE DB)"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-how-to"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -15,7 +16,9 @@ ms.author: "Pedro.Lopes"
1516
manager: craigg
1617
---
1718
# Change a SQL Server Authentication User Password (OLE DB)
18-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
19+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
20+
21+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
1922

2023
This sample shows how to use OLE DB to change the password of a user account under [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Authentication.
2124

‎docs/connect/oledb/ole-db-how-to/display-column-and-catalog-metadata-for-sparse-columns-ole-db.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Display Column and Catalog Metadata for Sparse Columns (OLE DB) | Microsoft Docs"
33
description: "Display column and catalog metadata for sparse columns (OLE DB)"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-how-to"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -15,7 +16,9 @@ ms.author: "Pedro.Lopes"
1516
manager: craigg
1617
---
1718
# Display Column and Catalog Metadata for Sparse Columns (OLE DB)
18-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
19+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
20+
21+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
1922

2023
This sample creates a table with three columns: a sparse column, a column that is not a sparse column, and a columnset column. The sample then displays OLE DB flags showing the column and catalog metadata for the non-sparse column and the columnset column.
2124

‎docs/connect/oledb/ole-db-how-to/enumerate-ole-db-data-sources-ole-db.md‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,9 +2,10 @@
22
title: "Enumerate OLE DB Data Sources (OLE DB) | Microsoft Docs"
33
description: "Enumerate OLE DB data sources using MSOLEDBSQL enumerator"
44
ms.custom: ""
5-
ms.date: "03/26/2018"
5+
ms.date: "06/14/2018"
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw"
8+
ms.component: "oledb|ole-db-how-to"
89
ms.reviewer: ""
910
ms.suite: "sql"
1011
ms.technology: connectivity
@@ -17,7 +18,9 @@ ms.author: "Pedro.Lopes"
1718
manager: craigg
1819
---
1920
# Enumerate OLE DB Data Sources (OLE DB)
20-
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
21+
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-asdbmi-md](../../../includes/appliesto-ss-asdb-asdw-pdw-asdbmi-md.md)]
22+
23+
[!INCLUDE[Driver_OLEDB_Download](../../../includes/driver_oledb_download.md)]
2124

2225
This sample shows how to use the enumerator object to list the data sources available.
2326

0 commit comments

Comments
 (0)