使用 OLE DB Driver for SQL Server 建置應用程式Building applications with 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 驅動程式的應用程式時, 有幾個問題會出現在遊戲中。When developing an application that uses the OLE DB Driver for SQL Server library, there are a number of issues that come into play. 本節中的主題將討論許多問題, 包括從 MDAC 升級到 OLE DB 驅動程式 SQL Server、使用 SQL Server 標頭和程式庫檔案的 OLE DB 驅動程式, 以及可與的 OLE DB 驅動程式搭配使用之各種連接字串的總覽。SQL Q 伺服器。The topics in this section discuss many of these issues including upgrading from MDAC to OLE DB Driver for SQL Server, using the OLE DB Driver for SQL Server header and library files, and an overview of the various connection strings that can be used with OLE DB Driver for SQL Server.

本節內容In this section

安裝 OLE DB Driver for SQL ServerInstalling OLE DB Driver for SQL Server
討論如何安裝 SQL Server 的 OLE DB 驅動程式、安裝各種元件的位置, 以及如何卸載 SQL Server OLE DB 驅動程式。Discusses how OLE DB Driver for SQL Server is installed, the locations that various components are installed to, and how to uninstall OLE DB Driver for SQL Server.

OLE DB Driver for SQL Server 的元件Components of OLE DB Driver for SQL Server
討論群組成 SQL Server OLE DB 驅動程式的元件, 包括程式庫、資源、說明和標頭檔。Discusses the components that make up OLE DB Driver for SQL Server including library, resource, help, and header files.

OLE DB Driver for SQL Server 使用連接字串關鍵字Using connection string keywords with OLE DB Driver for SQL Server
討論當透過 OLE DB Driver for SQL Server 連線到資料庫時,可以使用之各種類型的連接字串。Discusses the various types of connection strings that can be used when connecting to a database through OLE DB Driver for SQL Server.

使用 OLE DB Driver for SQL Server 標頭與程式庫檔案Using the OLE DB Driver for SQL Server header and library files
討論如何在應用程式中使用 SQL Server 標頭和程式庫檔案的 OLE DB 驅動程式。Discusses how to use the OLE DB Driver for SQL Server header and library files within an application.

將應用程式從 MDAC 更新為 OLE DB Driver for SQL ServerUpdating an application to OLE DB Driver for SQL Server from MDAC
討論 SQL Server 和 MDAC OLE DB 驅動程式之間的差異, 以及從 MDAC 升級到 OLE DB 驅動程式以進行 SQL Server 時應考慮的問題。Discusses the differences between OLE DB Driver for SQL Server and MDAC and issues that should be considered when upgrading from MDAC to OLE DB Driver for SQL Server.

從 SQL Server 2005 Native Client 更新應用程式Updating an application from SQL Server 2005 Native Client
討論從SQL Server 2005 (9.x)SQL Server 2005 (9.x) Native Client 升級為 SQL Server 的 OLE DB 驅動程式時, 應該考慮的問題。Discusses issues that should be considered when upgrading from SQL Server 2005 (9.x)SQL Server 2005 (9.x) Native Client to OLE DB Driver for SQL Server.

利用 OLE DB Driver for SQL Server 使用 ADOUsing ADO with OLE DB Driver for SQL Server
討論 ADO 如何使用 OLE DB 驅動程式 SQL Server 存取和使用SQL ServerSQL Server功能。Discusses how ADO can use OLE DB Driver for SQL Server to access and use SQL ServerSQL Server functionality.

OLE DB Driver for SQL Server 的支援原則Support policies for OLE DB Driver for SQL Server
討論如何將各種不同的資料存取元件用於 SQL Server 的 OLE DB 驅動程式的不同版本。Discusses how various data-access components can be used with different versions of OLE DB Driver for SQL Server.

另請參閱See Also

OLE DB Driver for SQL Server OLE DB Driver for SQL Server
OLE DB 使用說明主題OLE DB how-to topics