OLE DB Driver for SQL Server Programming

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

Download OLE DB driver

The OLE DB Driver for SQL Server is a low-level COM API that is used for accessing data. The OLE DB Driver for SQL Server is recommended for developing tools, utilities, or low-level components that need high performance. The OLE DB Driver for SQL Server is a native, high performance provider that accesses the SQL Server Tabular Data Stream (TDS) protocol directly.

OLE DB Driver for SQL Server provides OLE DB support to applications connecting to SQL Server.

The OLE DB Driver for SQL Server is an OLE DB version 2.0-compliant provider.

In This Section

• Creating an OLE DB Driver for SQL Server Application

• Data Source Objects (OLE DB)

• Commands

• Rowsets

• Stored Procedures

• BLOBs and OLE Objects

• Tables and Indexes

• Data Types (OLE DB)

• Schema Rowset Support (OLE DB)

• Table-Valued Parameters (OLE DB)

• Date and Time Improvements (OLE DB)

• Large CLR User-Defined Types (OLE DB)

• FILESTREAM Support

• Transactions

• Errors

• Service Principal Names (SPNs) in Client Connections (OLE DB)

• Sparse Columns Support (OLE DB)

• OLE DB Driver for SQL Server (OLE DB) Reference

• OLE DB How-to Topics

See Also

OLE DB Driver for SQL Server