New ODBC and OLEDB Driver (and SSMA) from MS

Hi,

in Vorbereitung auf den neuen SQL Server 2019 hat MS neue ODBC und OLEDB Treiber zum Download bereitgestellt.

In preparation for the new SQL Server 2019, MS has released new ODBC and OLEDB drivers for download.

 

MS Info OLEDB (ADO)
https://blogs.msdn.microsoft.com/sqlnativeclient/2019/02/22/ole-db-driver-18-2-for-sql-server-released/

Download
https://www.microsoft.com/en-us/download/details.aspx?id=56730

Connectionstring Access
Provider=MSOLEDBSQL; Server=myServerName\theInstanceName; Database=myDataBase; Trusted_Connection=yes;

------

MS Info ODBC (DAO)
https://blogs.msdn.microsoft.com/sqlnativeclient/2019/02/22/odbc-driver-17-3-for-sql-server-released/

Download - Always newest Version 
https://www.microsoft.com/en-us/download/details.aspx?id=56567

Connectionstring Access
ODBC;DRIVER=ODBC Driver 17 for SQL Server; SERVER=myServerName\theInstanceName; DATABASE=myDatabase; Trusted_Connection=yes;

------

ADO / DAO Background Article (de Soto)
https://accessexperts.com/blog/2018/09/11/new-sql-server-odbc-and-oledb-driver/

------

As each paid Office 365 License (see Office 365 E3 Plan.docx) also contains an Azure-Active-Directory License,
that may be important (found: DL / System Requirements):  

To use Azure AD Authentication please install the following before installing the ODBC / OLEDB Driver for SQL Server. 

-------------

Info SSMA - SQL Server Migration Assistant Info - Access
https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-2017

Download newest SSMA Access Version (2019_Sept_03 Vers: 8.4)
https://aka.ms/ssmaforaccess

mfg

Klaus