oledb-driver-for-sql-server-programming.md

title	OLE DB Driver for SQL Server Programming | Microsoft Docs
description	OLE DB Driver for SQL Server Programming
ms.custom
ms.date	06/12/2018
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	connectivity
ms.topic	reference
helpviewer_keywords	OLE DB Driver for SQL Server, about OLE DB Driver for SQL Server OLE DB, OLE DB Driver for SQL Server data access [OLE DB Driver for SQL Server], OLE DB MSOLEDBSQL, OLE DB OLE DB OLE DB Driver for SQL Server OLE DB Driver for SQL Server, OLE DB
author	pmasl
ms.author	pelopes

OLE DB Driver for SQL Server Programming

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

[!INCLUDEDriver_OLEDB_Download]

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 [!INCLUDEssNoVersion] Tabular Data Stream (TDS) protocol directly.

OLE DB Driver for SQL Server provides OLE DB support to applications connecting to [!INCLUDEssNoVersion].

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