OLE DB Driver for SQL Server 的支援原則Support policies for OLE DB Driver for SQL Server

適用於: 是SQL Server 是Azure SQL Database 是Azure Synapse Analytics (SQL DW) 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

下載OLE DB 驅動程式下載DownloadDownload OLE DB Driver

本文討論如何在 SQL Server 的 OLE DB 驅動程式中使用各種資料存取元件。This article discusses how various data-access components can be used with OLE DB Driver for SQL Server.

伺服器支援Server support

SQL Server 的 OLE DB 驅動程式支援透過 SQL Server 2019 (15.x)SQL Server 2019 (15.x)Azure SQL DatabaseAzure SQL DatabaseSQL Server 2012 (11.x)SQL Server 2012 (11.x) 連接。OLE DB Driver for SQL Server supports connections to SQL Server 2012 (11.x)SQL Server 2012 (11.x) through SQL Server 2019 (15.x)SQL Server 2019 (15.x), and Azure SQL DatabaseAzure SQL Database.

支援的作業系統版本Supported operating system versions

下表列出哪些作業系統支援 SQL Server 的 OLE DB 驅動程式。The following table lists which operating systems support OLE DB Driver for SQL Server.

支援的作業系統Supported operating systems
Microsoft Windows 8.1 + 2014 年4月更新 + KB2999226Microsoft Windows 8.1 + April 2014 update + KB2999226

Microsoft Windows 10Microsoft Windows 10

Microsoft Windows Server 2012 + KB2999226Microsoft Windows Server 2012 + KB2999226

Microsoft Windows Server 2012 R2 +四月2014更新 + KB2999226Microsoft Windows Server 2012 R2 + April 2014 update + KB2999226

Microsoft Windows Server 2016Microsoft Windows Server 2016

Microsoft Windows Server 2019Microsoft Windows Server 2019

ADO 支援原則ADO support policies

如果 ADO 應用程式不需要 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 或更新版本的任何功能,就可以使用 Windows 隨附的 SQLOLEDB OLE DB 提供者。ADO applications can use the SQLOLEDB OLE DB provider that is included with Windows if they don't require any of the features of SQL Server 2005 (9.x)SQL Server 2005 (9.x) or later.

ADO 應用程式可以使用 SQL Server 的 OLE DB 驅動程式,但如果它們這麼做,就必須在連接字串中指定 DataTypeCompatibility=80ADO applications can use the OLE DB Driver for SQL Server, but if they do so they must specify DataTypeCompatibility=80 in the connection strings. 當連接字串中存在 DataTypeCompatibility=80 時,只能使用 SQL Server 2005 (9.x)SQL Server 2005 (9.x) 的功能。Only features from SQL Server 2005 (9.x)SQL Server 2005 (9.x) are available when DataTypeCompatibility=80 is present in the connection strings.

OLE DB 支援原則OLE DB support policies

應用程式應該使用 Windows 作業系統隨附的 OLE DB 提供者 (SQLOLEDB)。Applications can use the OLE DB provider (SQLOLEDB) included with the Windows operating system. 不過,這處於維護模式,且不再更新。However, that is in maintenance mode and no longer updated. 請改用 SQL Server 的 OLE DB 驅動程式(內含 MSOLEDBSQL.H)。Use the OLE DB Driver for SQL Server (MSOLEDBSQL) instead.

另請參閱See also

使用 OLE DB Driver for SQL Server 建置應用程式Building applications with OLE DB Driver for SQL Server