title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
---|---|---|---|---|---|---|---|---|---|---|---|
Creating an OLE DB Driver for SQL Server Application |
Learn about the steps necessary to create an OLE DB Driver for SQL Server application and find other resources. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
[!INCLUDE SQL Server]
[!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.