| title | How-to articles (OLE DB driver) | |
|---|---|---|
| description | Use these how-to articles to understand how the OLE DB Driver for SQL Server connects to a server, runs a command, and processes results. | |
| author | David-Engel | |
| ms.author | davidengel | |
| ms.reviewer | randolphwest | |
| ms.date | 10/02/2023 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | reference | |
| ms.custom |
|
|
| helpviewer_keywords |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDE Driver_OLEDB_Download]
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.
- 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)