MS OLE DB Driver for SQL Server vs MS OLE DB Driver 19 for SQL Server

• MK Morris

  SSC-Addicted

  Points: 492

  More actions

  August 21, 2023 at 8:26 pm

  #4267444

  I have two OLE DB drivers installed.

  Microsoft OLE DB Driver for SQL Server

  and

  Microsoft OLE DB Driver 19 for SQL Server

  https://learn.microsoft.com/en-us/sql/connect/oledb/major-version-differences?view=sql-server-ver16#Driver%20name%20changes

  Is it possible to uninstall the un-versioned driver (Microsoft OLE DB Driver for SQL Server) without breaking anything?  Or must it be retained due to possible software dependency?

  Also, it looks like the OLE DB Drivers may be updated with Windows Updates.  Is that correct?  Or must updates be installed manually?

   

• MK Morris

  SSC-Addicted

  Points: 492

  More actions

  August 21, 2023 at 8:44 pm

  #4267468

  I may have figured out the difference between the two.

  In Control panel I see Microsoft OLE DB Driver 19 for SQL Server with a Version of 19.3.1.0.

  This appears to be https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1931

  Microsoft OLE DB Driver for SQL Server is listed as Version 18.6.6.0.

  This appears to be version 18.6.6 https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1866