Microsoft Ole Db Provider For Sql Server

We are pleased to announce the release of the Microsoft OLE DB Driver for SQL Server, as we had previously announced! This new driver follows the same release model as all the other SQL Server drivers, which means that it’s maintained out-of-band with the SQL Server Database Engine lifecycle. You can download the new driver here.

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.

Sep 17, 2018  Microsoft OLE DB Provider for SQL Server__Login failed for user '(null)'. I have been using my workstation on a Windows 2000 SQL Server network for several weeks without any issues. I am using Activant Prophet 21 accounting software along with MS Office 2010 Professional on a Windows 7 Ultimate platform.

This new Microsoft OLE DB Driver for SQL Server (msoledbsql) supports connectivity to SQL Server (versions 2012 to 2017), Azure SQL Database and Azure SQL Data Warehouse. Also, keep in mind SNAC OLE DB (sqlncli) and MDAC/WDAC OLE DB (sqloledb) continues to be deprecated. For more information, refer to the page OLE DB Driver for SQL Server.

As part of the new release, OLE DB documentation was also reviewed and updated, available in OLE DB Driver for SQL Server Programming.

* Note that SNAC 11 does not support features released with SQL Server 2014 and SQL Server 2016 that were not available as part of SQL Server 2012, such as Transparent Network IP Resolution, Always Encrypted, Azure AD Authentication, Bulk Copy and Table Value Parameters.

To use the new driver in existing applications, you should plan to convert your connection strings from sqlncli<x> or sqloledb, to msoledbsql. For example, for a trusted connection using SQL Native Client (SNAC11), plan to convert from:

Provider=SQLNCLI11; Server=myServerNametheInstanceName;Database=myDataBase;
Trusted_Connection=yes;

to:

Provider=MSOLEDBSQL; Server=myServerNametheInstanceName; Database=myDataBase;
Trusted_Connection=yes;

For a trusted connection using the MDAC/WDAC OLE DB Provider for SQL Server, plan to convert from:

Provider

Provider=sqloledb; Data Source=myServerNametheInstanceName;
Initial Catalog=myDataBase; Integrated Security=SSPI;

to:

Sql Server Oledb Driver Download

Provider=MSOLEDBSQL; Server=myServerNametheInstanceName; Database=myDataBase;
Trusted_Connection=yes;

Pedro Lopes (@SQLPedro) – Senior Program Manager

We are pleased to announce the release of the Microsoft OLE DB Driver for SQL Server, as we had previously announced! This new driver follows the same release model as all the other SQL Server drivers, which means that it’s maintained out-of-band with the SQL Server Database Engine lifecycle. You can download the new driver here.

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.

This new Microsoft OLE DB Driver for SQL Server (msoledbsql) supports connectivity to SQL Server (versions 2012 to 2017), Azure SQL Database and Azure SQL Data Warehouse. Also, keep in mind SNAC OLE DB (sqlncli) and MDAC/WDAC OLE DB (sqloledb) continues to be deprecated. For more information, refer to the page OLE DB Driver for SQL Server.

As part of the new release, OLE DB documentation was also reviewed and updated, available in OLE DB Driver for SQL Server Programming.

* Note that SNAC 11 does not support features released with SQL Server 2014 and SQL Server 2016 that were not available as part of SQL Server 2012, such as Transparent Network IP Resolution, Always Encrypted, Azure AD Authentication, Bulk Copy and Table Value Parameters.

To use the new driver in existing applications, you should plan to convert your connection strings from sqlncli<x> or sqloledb, to msoledbsql. For example, for a trusted connection using SQL Native Client (SNAC11), plan to convert from:

Microsoft Ole Db Provider For Sql Server Linked Server

For

Provider=SQLNCLI11; Server=myServerNametheInstanceName;Database=myDataBase;
Trusted_Connection=yes;

to:

Provider=MSOLEDBSQL; Server=myServerNametheInstanceName; Database=myDataBase;
Trusted_Connection=yes;

For a trusted connection using the MDAC/WDAC OLE DB Provider for SQL Server, plan to convert from:

Provider=sqloledb; Data Source=myServerNametheInstanceName;
Initial Catalog=myDataBase; Integrated Security=SSPI;

to:

Provider=MSOLEDBSQL; Server=myServerNametheInstanceName; Database=myDataBase;
Trusted_Connection=yes;

Sqloledb Driver

Pedro Lopes (@SQLPedro) – Senior Program Manager