04-08-2018 02:51 AM
04-08-2018 02:51 AM
As promised, the new SQL Server Native Client 18 is now available to download. Either Ben Clothier or I will be testing Azure authentication and other aspects of ADODB and be providing feedback soon! In the meantime, check out the announcement and other documents below :
OLEDB Driver Info: bit.ly/OLEDB18
ADODB Info with Native Client 18: bit.ly/ADODB18
Download Native Client 18 Here: bit.ly/SNC18Down
04-09-2018 12:05 AM
I'm glad to see a major update to the data access driver for SQL Server and Azure SQL for Microsoft Access (as well as .NET and elsewhere).
This provides much-needed support for TLS 1.2 with Microsoft OLE DB Driver for SQL Server 18 (MSOLEDBSQL) – the key component provided with SQL Server Native Client (SNAC) v18 update and new suggested default driver – while maintaining backwards compatibility with SQL Server Native Client 11 (SQLNCLI11).
For easier reference, here is the direct (and clickable) link for downloading this new SQL Server driver:
As well for Juan's other links:
04-09-2018 12:07 AM
With this update, Microsoft OLE DB Driver for SQL Server 18 is now the new suggested driver for connecting to SQL Server and Azure SQL databases from Access, ADO and beyond.
Specifically that means using Provider=MSOLEDBSQL in connection strings, vs. older
SQLOLEDB (plus DataTypeCompatibility=80 if want to return old ADO data types) or SQL Server Native Client (SQLNCLI) – as compared further in updated OLE DB Driver for SQL Server docs.
So not only was OLE DB undeprecated in 2018, it's now the suggested driver for connecting to SQL Server and Azure SQL. Whereas up to this point, ODBC was suggested for use in the Access Import or link to data in an SQL Server database documentation ("ODBC Driver 13 for SQL Server" in Create New Data Source driver list).
04-09-2018 12:08 AM
Use of the OLE DB driver enables support for new SQL Server 2005+ features like multiple active result sets (MARS), query notifications, user-defined types (UDTs), and the new xml data type, as detailed in updated ADO programming docs, as may be helpful for ADO.NET and VBA automation.
Besides TLS 1.2, this new OLE DB 18 SQL Server driver provides availability/replication enhancements with multi-subnet failover support.
Thanks for letting us know about this, Juan!