You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/connect/oledb/download-oledb-driver-for-sql-server.md
+9-9Lines changed: 9 additions & 9 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Download Microsoft OLE DB Driver for SQL Server | Microsoft Docs"
3
3
description: "Download the Microsoft OLE DB Driver for SQL Server to develop native Windows applications that connect to SQL Server and Azure SQL Database."
4
-
ms.date: 06/18/2021
4
+
ms.date: 12/08/2021
5
5
ms.prod: sql
6
6
ms.technology: connectivity
7
7
ms.topic: conceptual
@@ -18,15 +18,15 @@ The OLE DB Driver for SQL Server is a stand-alone data access application progra
18
18
19
19
The redistributable installer for Microsoft OLE DB Driver for SQL Server installs the client components required during run time to take advantage of newer SQL Server features. Starting with version 18.3, the installer also includes and installs the Microsoft Active Directory Authentication Library (ADAL.dll).
20
20
21
-
Microsoft OLE DB Driver 18.6 for SQL Server is the latest general availability (GA) version. If you have a previous version of Microsoft OLE DB Driver 18 for SQL Server installed, installing 18.6 upgrades it to 18.6.
21
+
Microsoft OLE DB Driver 18.6.3 for SQL Server is the latest general availability (GA) version. If you have a previous version of Microsoft OLE DB Driver 18 for SQL Server installed, installing 18.6.3 upgrades it to 18.6.3.
22
22
23
23
**[ Download Microsoft OLE DB Driver for SQL Server (x64)](https://go.microsoft.com/fwlink/?linkid=2164384)**
24
-
**[ Download Microsoft OLE DB Driver for SQL Server (x86)](https://go.microsoft.com/fwlink/?linkid=2164408)**
24
+
**[ Download Microsoft OLE DB Driver for SQL Server (x86)](https://go.microsoft.com/fwlink/?linkid=2183084)**
25
25
26
26
### Version information
27
27
28
-
- Release number: 18.6.0
29
-
- Released: June 18, 2021
28
+
- Release number: 18.6.3
29
+
- Released: December 2021
30
30
31
31
> [!Note]
32
32
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please select **Read in English** at the top of this page. You can download different languages from the US-English version site by selecting [available languages](#available-languages).
@@ -35,11 +35,11 @@ Microsoft OLE DB Driver 18.6 for SQL Server is the latest general availability (
35
35
36
36
This release of Microsoft OLE DB Driver for SQL Server can be installed in the following languages:
37
37
38
-
Microsoft OLE DB Driver 18.6 for SQL Server (x64):
This topic describes OLE DB properties and member functions that support service principal names (SPNs) in client applications. For more information about SPNs in client applications, see [Service Principal Name (SPN) Support in Client Connections](../../oledb/features/service-principal-name-spn-support-in-client-connections.md). For a sample, see [Integrated Kerberos Authentication (OLE DB)](../../oledb/ole-db-how-to/integrated-kerberos-authentication-ole-db.md).
20
+
This article describes OLE DB properties and member functions that support service principal names (SPNs) in client applications. For more information about SPNs in client applications, see [Service Principal Name (SPN) Support in Client Connections](../../oledb/features/service-principal-name-spn-support-in-client-connections.md). For a sample, see [Integrated Kerberos Authentication (OLE DB)](../../oledb/ole-db-how-to/integrated-kerberos-authentication-ole-db.md).
21
21
22
22
## Provider Initialization String Keywords
23
23
The following provider initialization string keywords support SPNs in OLE DB applications. In the following table, the values in the keyword column are used for the provider string of IDBInitialize::Initialize. The values in the description column are used in initialization strings when connecting using ADO or IDataInitialize::GetDataSource.
@@ -28,13 +28,14 @@ ms.author: v-davidengel
28
28
|FailoverPartnerSPN|Failover Partner SPN|The SPN for the failover partner. The default value is an empty string, which causes OLE DB Driver for SQL Server to use the default, provider-generated SPN.|
29
29
30
30
## Data Source Initialization Properties
31
-
The following properties in the **DBPROPSET_SQLSERVERDBINIT** property set allow applications to specify SPNs.
31
+
The following properties in the **DBPROPSET_SQLSERVERDBINIT** property set allow applications to specify or read SPNs.
32
32
33
33
|Name|Type|Usage|
34
34
|----------|----------|-----------|
35
-
|SSPROP_INIT_SERVERSPN|VT_BSTR, read/write|Specifies the SPN for the server. The default value is an empty string, which causes OLE DB Driver for SQL Server to use the default, provider-generated SPN.|
36
-
|SSPROP_INIT_FAILOVERPARTNERSPN|VT_BSTR, read/write|Specifies the SPN for the failover partner. The default value is an empty string, which causes OLE DB Driver for SQL Server to use the default, provider-generated SPN.|
37
-
35
+
|SSPROP_INIT_SERVERSPN|VT_BSTR, read/write|Specifies the SPN for the server. The default value is an empty string, which causes OLE DB Driver for SQL Server to use the default, provider-generated SPN.|
36
+
|SSPROP_INIT_FAILOVERPARTNERSPN|VT_BSTR, read/write|Specifies the SPN for the failover partner. The default value is an empty string, which causes OLE DB Driver for SQL Server to use the default, provider-generated SPN.|
37
+
| SSPROP_INIT_DISCOVEREDSERVERSPN | VT_BSTR, read only | Used to query the server SPN of a connection. (Version 18.6.3 or later) |
38
+
38
39
## Data Source Properties
39
40
The following properties in the **DBPROPSET_SQLSERVERDATASOURCEINFO** property set allow applications to discover the authentication method.
For the x86 driver: [Chinese (Simplified)](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x804) | [Chinese (Traditional)](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x404) | [English (United States)](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x409) | [French](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x40c) | [German](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x407) | [Italian](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x410) | [Japanese](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x411) | [Korean](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x412) | [Portuguese (Brazil)](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x416) | [Russian](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x419) | [Spanish](https://go.microsoft.com/fwlink/?linkid=2183084&clcid=0x40a)
33
+
34
+
### Features added
35
+
36
+
| Feature added | Details |
37
+
| :------------ | :------ |
38
+
| Removal of dependency on vcruntime140_1.dll | To remove the requirement to install visual studio in some scenarios, we removed all dependencies to vcruntime140_1.dll. |
39
+
| Enable querying server SPN from connection | During a connection attempt where AAD authentication has been selected, the server will send a FEDAUTHINFO packet. This packet contains the server's SPN that must be used to generate the access token. Client's can query this value after a connection attempt is made (on success of failure) through the SSPROP_INIT_DISCOVERDSERVERSPN property in DBPROPSET_SQLSERVERDBINIT. |
40
+
41
+
### Bugs fixed
42
+
43
+
| Bug fixed | Details |
44
+
| :-------- | :------ |
45
+
| Fixed an issue where string values were being padded with zeros. | Fixed a bug, which resulted in string values being truncated and then padded with zeros in BCP. |
[Download x86 installer](https://go.microsoft.com/fwlink/?linkid=2164408)
@@ -46,8 +71,6 @@ If you need to download the installer in a language other than the one detected
46
71
| Fixed an accessibility issue. | Fixed an accessibility issue in the user interface of [Universal Data Link (UDL)](help-topics\data-link-pages.md). This accessibility issue resulted in the *Browse* button not being announced by screen reader software. |
47
72
| Fixed crash in scenarios involving Multiple Active Result Sets. | Fixed a bug, which could result in the driver crashing in some scenarios involving [Multiple Active Result Sets (MARS)](features/using-multiple-active-result-sets-mars.md).|
0 commit comments