SQL Server: OLE-DB

The PROGID for the (official?, deprecated?) provider for SQL Server is SQLNCLI11 (Microsoft SQL Server Native Client OLE DB Provider).

Three generations of OLE DB providers/drivers

Microsoft provides three distinct generations of OLE DB providers/drivers for SQL Server:

Microsoft OLE DB Provider for SQL Server	SQLOLEDB	Although this generation ships with Windows DAC, it is not maintained anymore and therefore not recommended when developping new applications.
SQL Server Native Client	SNAC / SQLNCLI(?)	This provider shipped with SQL Server 2005 (9.x) through SQL Server 2017. This provider was deprecated in 2011 and is therefore not recommended for developping new applications.
Microsoft OLE DB Driver for SQL Server	MSOLEDBSQL	Apparently, this driver is the result of undeprecating SQLOLEDB. Microsoft seems to promise that this driver also includes the functionality of SQLNCLI.

SNAC is a term that interchangably referred to ODBC and OLE DB drivers for SQL Server.

SNAC 10 through SNAC 13 each consisted of a single DLL.

The chosen provider is indicated with the provider attribute:

provider=SQLOLEDB: …
provider=SQLNCLI11: …
provider=MSOLEDBSQL: …

trusted_connection=yes

server=serverName\instanceName

database=…