使用 SQL Server Native Client 建立應用程式Building Applications with SQL Server Native Client

適用於: 是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

當您開發使用 SQL ServerSQL Server Native Client 程式庫的應用程式時,會遇到一些問題。When developing an application that uses the SQL ServerSQL Server Native Client library, there are a number of issues that come into play. 本章節的主題將討論其中的許多問題,包括從 MDAC 升級到 SQL ServerSQL Server Native Client (使用 SQL ServerSQL Server Native Client 標頭檔和程式庫檔案),以及可搭配 SQL ServerSQL Server Native Client 使用的各種連接字串概觀。The topics in this section discuss many of these issues including upgrading from MDAC to SQL ServerSQL Server Native Client, using the SQL ServerSQL Server Native Client header and library files, and an overview of the various connection strings that can be used with SQL ServerSQL Server Native Client.

本節內容In This Section

安裝 SQL Server Native ClientInstalling SQL Server Native Client
討論如何安裝 SQL ServerSQL Server Native Client、各種元件的安裝位置,以及如何解除安裝 SQL ServerSQL Server Native Client。Discusses how SQL ServerSQL Server Native Client is installed, the locations that various components are installed to, and how to uninstall SQL ServerSQL Server Native Client.

SQL Server Native Client 的元件Components of SQL Server Native Client
討論組成 SQL ServerSQL Server Native Client 的元件,包括程式庫、資源、說明和標頭檔案。Discusses the components that make up SQL ServerSQL Server Native Client including library, resource, help, and header files.

搭配 SQL Server Native Client 使用連接字串關鍵字Using Connection String Keywords with SQL Server Native Client
討論當透過 SQL ServerSQL Server Native Client 連接到資料庫時,可以使用之各種類型的連接字串。Discusses the various types of connection strings that can be used when connecting to a database through SQL ServerSQL Server Native Client.

使用 SQL Server Native Client 標頭檔與程式庫檔案Using the SQL Server Native Client Header and Library Files
討論如何在應用程式內使用 SQL ServerSQL Server Native Client 標頭檔和程式庫檔案。Discusses how to use the SQL ServerSQL Server Native Client header and library files within an application.

從 MDAC 將應用程式更新至 SQL Server Native ClientUpdating an Application to SQL Server Native Client from MDAC
討論 SQL ServerSQL Server Native Client 與 MDAC 之間的差異以及從 MDAC 升級到 SQL ServerSQL Server Native Client 時所應該考量的問題。Discusses the differences between SQL ServerSQL Server Native Client and MDAC and issues that should be considered when upgrading from MDAC to SQL ServerSQL Server Native Client.

從 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 ServerSQL Server 中的 SQL Server 2012 (11.x)SQL Server 2012 (11.x) Native Client 時所應該考量的問題。Discusses issues that should be considered when upgrading from SQL Server 2005 (9.x)SQL Server 2005 (9.x) Native Client to SQL ServerSQL Server Native Client in SQL Server 2012 (11.x)SQL Server 2012 (11.x).

使用 ADO 搭配 SQL Server Native ClientUsing ADO with SQL Server Native Client
討論 ADO 要如何使用 SQL ServerSQL Server Native Client 來存取及使用 SQL ServerSQL Server 功能。Discusses how ADO can use SQL ServerSQL Server Native Client to access and use SQL ServerSQL Server functionality.

SQL Server Native Client 的支援原則Support Policies for SQL Server Native Client
討論要如何搭配不同版本的 SQL ServerSQL Server Native Client 使用各種資料存取元件。Discusses how various data-access components can be used with different versions of SQL ServerSQL Server Native Client.

使用 SQL Server Native Client 連接到 Azure SQL DatabaseConnecting to an Azure SQL Database Using SQL Server Native Client
討論如何使用 SQL DatabaseSQL Database Native Client 連接至 SQL ServerSQL ServerDiscusses how to connect to a SQL DatabaseSQL Database using SQL ServerSQL Server Native Client.

另請參閱See Also

SQL Server Native Client 程式設計 SQL Server Native Client Programming
ODBC 的使用說明主題 ODBC How-to Topics
OLE DB 的使用說明主題OLE DB How-to Topics