Building applications with OLE DB Driver for SQL Server
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for