Skip to content

Commit 8cd71a4

Browse files
authored
Merge pull request MicrosoftDocs#1582 from corob-msft/cr-dedupe-data-topic
Remove duplicate topic, update TOC and redirection
2 parents ce21f6d + 0812b65 commit 8cd71a4

4 files changed

Lines changed: 11 additions & 32 deletions

File tree

.openpublishing.redirection.json

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6700,6 +6700,11 @@
67006700
"redirect_url": "/cpp/porting/visual-cpp-porting-and-upgrading-guide",
67016701
"redirect_document_id": false
67026702
},
6703+
{
6704+
"source_path": "docs/porting/porting-data-applications.md",
6705+
"redirect_url": "/cpp/data/data-access-programming-mfc-atl",
6706+
"redirect_document_id": false
6707+
},
67036708
{
67046709
"source_path": "docs/preprocessor/index.md",
67056710
"redirect_url": "/cpp/preprocessor/c-cpp-preprocessor-reference",

docs/data/data-access-programming-mfc-atl.md

Lines changed: 5 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: "Data Access Programming (MFC-ATL)"
3-
ms.date: "11/04/2016"
3+
ms.date: "11/16/2018"
44
helpviewer_keywords: ["MFC [C++], data access applications", "databases [C++], MFC", "OLE DB [C++], data access technologies", "data [C++], data access technologies", "data access [C++], class libraries for databases"]
55
ms.assetid: def97b2c-b5a6-445f-afeb-308050fd4852
66
---
@@ -10,9 +10,11 @@ Over the years, Visual C++ has provided several ways to work with databases. In
1010

1111
OLE DB is a low-level, high-performance API based on the COM specification, and is only supported on Windows. Use OLE DB if your program is accessing [linked servers](/sql/relational-databases/linked-servers/linked-servers-database-engine). ATL provides OLE DB templates that make it easier to create custom OLE DB providers and consumers. The most recent version of OLE DB shipped in SQL Native Client 11.
1212

13+
## Porting data applications
14+
1315
If your legacy application uses OLE DB or the higher-level ADO interface to connect to SQL Server, and you are not accessing linked servers, you should consider migrating to ODBC in the near future. If you do not require cross-platform portability or the latest SQL Server features, you can possibly use the Microsoft OLE DB Provider for ODBC (MSDASQL). MSDASQL allows applications that are built on OLE DB and ADO (which uses OLEDB internally) to access data sources through an ODBC driver. As with any translation layer, MSDASQL can impact database performance. You should test to determine whether the impact is significant for your application. MSDASQL ships with the Windows operating system, and Windows Server 2008 & Windows Vista SP1 are the first Windows releases to include a 64-bit version of the technology.
1416

15-
The SQL Native Client component (SNAC), which packages OLE DB and ODBC drivers in a single DLL, is deprecated for ODBC applications. The SQL Server 2012 version of SNAC (SQLNCLI11.DLL) ships with SQL Server 2016 because other SQL Server components depend on it. However, new C++ applications that connect to SQL Server or Azure SQL Database via ODBC should use [the most recent ODBC driver](https://docs.microsoft.com/sql/connect/odbc/download-odbc-driver-for-sql-server). For more information, see [SQL Server Native Client Programming](/sql/relational-databases/native-client/sql-server-native-client-programming)
17+
The SQL Native Client component (SNAC), which packages OLE DB and ODBC drivers in a single DLL, is deprecated for ODBC applications. The SQL Server 2012 version of SNAC (SQLNCLI11.DLL) ships with SQL Server 2016 because other SQL Server components depend on it. However, new C++ applications that connect to SQL Server or Azure SQL Database via ODBC should use [the most recent ODBC driver](/sql/connect/odbc/download-odbc-driver-for-sql-server). For more information, see [SQL Server Native Client Programming](/sql/relational-databases/native-client/sql-server-native-client-programming)
1618

1719
If you use C++/CLI, you can continue to use ADO.NET as always. For more information, see [Data Access Using ADO.NET (C++/CLI)](../dotnet/data-access-using-adonet-cpp-cli.md), and [Accessing data in Visual Studio](/visualstudio/data-tools/accessing-data-in-visual-studio).
1820

@@ -23,5 +25,4 @@ For more information about the history of data access technologies on Microsoft
2325
## See Also
2426

2527
[Data Access](data-access-in-cpp.md)<br/>
26-
[Microsoft Open Database Connectivity (ODBC)](https://docs.microsoft.com/sql/odbc/microsoft-open-database-connectivity-odbc)<br/>
27-
[Data Access Technologies Road Map](https://msdn.microsoft.com/library/ms810810.aspx)
28+
[Microsoft Open Database Connectivity (ODBC)](/sql/odbc/microsoft-open-database-connectivity-odbc)<br/>

docs/porting/TOC.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
## [C++ Binary Compatibility between 2015 and 2017](binary-compat-2015-2017.md)
55
## [Overview of potential upgrade issues (Visual C++)](overview-of-potential-upgrade-issues-visual-cpp.md)
66
## [Porting 3rd-party libraries](porting-third-party-libraries.md)
7-
## [Porting data applications](porting-data-applications.md)
7+
## [Porting data applications](../data/data-access-programming-mfc-atl.md)
88
## [Porting and Upgrading: Examples and Case Studies](porting-and-upgrading-examples-and-case-studies.md)
99
### [Porting Guide: MFC Scribble](porting-guide-mfc-scribble.md)
1010
### [Porting Guide: COM Spy](porting-guide-com-spy.md)

docs/porting/porting-data-applications.md

Lines changed: 0 additions & 27 deletions
This file was deleted.

0 commit comments

Comments
 (0)