OLE DB How-to articles

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

Download OLE DB driver

To use the OLE DB Driver for SQL Server, you have to understand how to make a connection to the server, execute the command, and process the results.

In this section

• Processing Results How-to Topics (OLE DB)
• Set Large Data (OLE DB)
• Enumerate OLE DB Data Sources (OLE DB)
• Bulk Copy Data Using IRowsetFastLoad (OLE DB)
• Obtain a FAST_FORWARD Cursor
• Retrieve Rows Using Bookmarks (OLE DB)
• Fetch Columns by Using IRow::GetColumns (or IRow::Open) and ISequentialStream
• Fetch Columns Using IRow::GetColumns (OLE DB)
• Change a SQL Server Authentication User Password (OLE DB)
• Use Enhanced Date and Time Features (OLE DB)
• FILESTREAM and OLE DB
• Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)
• Use Large CLR UDTs (OLE DB)
• Display Column and Catalog Metadata for Sparse Columns (OLE DB)
• Integrated Kerberos Authentication (OLE DB)
• Use Table-Valued Parameters (OLE DB)

Related content

• Microsoft OLE DB Driver for SQL Server