Creating an OLE DB Driver for SQL Server Application

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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

See also

OLE DB Driver for SQL Server Programming