SQL Server 2008 R2 Native Client (OLE DB)

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

SQL Server Native Client provides OLE DB support to applications connecting to versions of SQL Server from SQL Server 2000 and later.

The SQL Server Native Client OLE DB provider is an OLE DB version 2.0–compliant provider.

In This Section

• Creating a SQL Server Native Client OLE DB Provider 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/Time Improvements (OLE DB)

• Large CLR User-Defined Types (OLE DB)

• FILESTREAM Support (OLE DB)

• Transactions

• Errors

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

• Sparse Columns Support (OLE DB)

• SQL Server Native Client (OLE DB) Reference

• OLE DB How-to Topics

See Also

Other Resources

SQL Server 2008 R2 Native Client Programming