| title | Creating an OLE DB Driver for SQL Server Application | Microsoft Docs | |||
|---|---|---|---|---|
| description | Creating an OLE DB Driver for SQL Server application | |||
| ms.custom | ||||
| ms.date | 06/14/2018 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |||
| ms.reviewer | ||||
| ms.technology | connectivity | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
|||
| author | pmasl | |||
| ms.author | pelopes |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
[!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.