Building applications with OLE DB Driver for SQL Server

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Download OLE DB driver

When developing an application that uses the OLE DB Driver for SQL Server library, there are a number of issues that come into play. 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

Installing 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.

Components of 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.

Using connection string keywords with 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.

Using the OLE DB Driver for SQL Server header and library files
Discusses how to use the OLE DB Driver for SQL Server header and library files within an application.

Updating an application to OLE DB Driver for SQL Server from MDAC
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.

Updating an application from SQL Server 2005 Native Client
Discusses issues that should be considered when upgrading from SQL Server 2005 (9.x) Native Client to OLE DB Driver for SQL Server.

Using ADO with OLE DB Driver for SQL Server
Discusses how ADO can use OLE DB Driver for SQL Server to access and use SQL Server functionality.

Support policies for 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 how-to topics