使用 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

開發使用 OLE DB Driver for SQL Server 程式庫的應用程式時,會遇到一些問題。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 Driver for SQL Server (使用 OLE DB Driver for SQL Server 標頭檔和程式庫檔案),以及可搭配 OLE DB Driver for SQL Server 使用的各種連接字串概觀。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
討論如何安裝 OLE DB Driver for SQL Server、各種元件的安裝位置,以及如何解除安裝 OLE DB Driver for SQL Server。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
討論組成 OLE DB Driver for SQL Server 的元件,包括程式庫、資源、說明和標頭檔案。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
討論如何在應用程式內使用 OLE DB Driver for SQL Server 標頭檔和程式庫檔案。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
討論 OLE DB Driver for SQL Server 與 MDAC 之間的差異以及從 MDAC 升級到 OLE DB Driver for 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 升級到 OLE DB Driver for SQL Server 時所應該考量的問題。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 Driver for 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
討論要如何搭配不同版本的 OLE DB Driver for SQL Server 使用各種資料存取元件。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