Microsoft OLE DB Driver for SQL Server

Eintrag zuletzt aktualisiert am: 28.07.2019

OLE DB-basierter Datenbanktreiber für den Microsoft SQL Server.

Microsoft hatte OLE DB für SQL Server ("Microsoft OLE DB Provider") in 2011 als "veraltetert" erklärt. Seit 2018 gibt es aber einen neuen Treiber "Microsoft OLE DB Driver for SQL Server"

Alter Treiber
Provider=sqloledb; Data Source=myServerName\theInstanceName;
Initial Catalog=myDataBase; Integrated Security=SSPI;

Neuer Treiber
Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase;
Trusted_Connection=yes;

Achtung

"There are three distinct generations of Microsoft OLE DB providers for SQL Server. The first "Microsoft OLE DB Provider for SQL Server" (SQLOLEDB) still ships as part of Windows Data Access Components. This provider will not be updated with new features and it is not recommended to use this driver for new development. Starting in SQL Server 2005, the SQL Server Native Client includes an OLE DB provider interface (SQLNCLI) and is the OLE DB provider that shipped with SQL Server 2005 through SQL Server 2017. It was announced as deprecated in 2011 and it is not recommended to use this driver for new development. In 2017, OLE DB data access technology was subsequently undeprecated and a new planned release was announced for 2018. The new OLE DB provider is called the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) and is currently maintained and supported."
https://docs.microsoft.com/en-us/sql/connect/connect-history?view=sqlallproducts-allversions#Microsoft/Windows%20Data%20Access%20Components%20(MDAC/WDAC)

The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
[https://docs.microsoft.com/en-us/sql/ado/guide/appendixes/microsoft-ole-db-provider-for-sql-server?view=sql-server-2017]

March 30, 2018
"The new Microsoft OLE DB Driver for SQL Server is the 3rd generation of OLE DB Drivers for SQL Server, introduces multi-subnet failover capabilities, and keeps up with the existing feature set of SQL Server Native Client (SNAC) 11*, including the latest TLS 1.2 standards. As such, backwards compatibility with applications currently using SNAC 11 is maintained in this new release."
https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/