Support for Microsoft OLE DB driver for SQL Server (MSOLEDBSQL)

Jennifer Taylor – Software Test Manager, FabGuard Product Group, Newton MA

The OLE DB Driver for SQL Server is a stand-alone data access application programming interface (API), used for OLE DB, and was just released in June 2018. It provides new functionality above and beyond what was supplied with the old SQLOLEDB (Windows DAC, formerly Microsoft Data Access Components, or MDAC). Note that unlike SQLOLEDB, the new MSOLEDBSQL driver is not built in to Windows and must be installed on each computer where it should be used instead of SQLOLEDB.

The new MSOLEDBSQL driver can be used to connect to:

  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012

The new MSOLEDBSQL driver can be installed on computers running:

  • Windows 10
  • Windows 8.1
  • Windows Server 2016
  • Windows Server 2012 and 2012 R2

Click here for more detailed information and to download the installer for the new MSOLEDBSQL.

Support for the previous SQLOLEDB driver

The previous SQLOLEDB driver is still supported. When opening a connection to an MS SQL Server database, FabGuard first tries to use MSOLEDBSQL. If that fails, FabGuard then tries to use SQLOLEDB.