Creating an OLE DB Driver for SQL Server Application

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

Creating an OLE DB Driver for SQL Server application involves these steps:

1. Establishing a connection to a data source.
2. Executing a command.
3. Processing the results.

Note

When possible, use Windows Authentication. If Windows Authentication is not available, prompt users to enter their credentials at run time. Avoid storing credentials in a file. If you must persist credentials, you should encrypt them with the Win32 cryptoAPI.

In this section

• Establishing a Connection to a Data Source
• Executing a Command
• Processing Results
• About OLE DB Properties
• Using the OUTPUT Clause with OLE DB in OLE DB Driver for SQL Server

See also

OLE DB Driver for SQL Server Programming