| title | Creating an OLE DB Driver for SQL Server Application | |||
|---|---|---|---|---|
| description | Learn about the steps necessary to create an OLE DB Driver for SQL Server application and find other resources. | |||
| author | David-Engel | |||
| ms.author | davidengel | |||
| ms.date | 06/14/2018 | |||
| 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]
[!INCLUDEDriver_OLEDB_Download]
Creating an OLE DB Driver for SQL Server application involves these steps:
- Establishing a connection to a data source.
- Executing a command.
- 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.