Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
 SQL Server 
 Azure SQL Database 
 Azure SQL Managed Instance 
 Azure Synapse Analytics 
 Analytics Platform System (PDW)
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.
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