Creating a SQL Server Native Client OLE DB Provider Application

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

Creating a SQL Server Native Client OLE DB provider application involves these steps:

  1. Establishing a connection to a data source.

  2. Executing a command.

  3. Processing the results.

System_CAPS_ICON_note.jpg 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.

SQL Server Native Client (OLE DB)

Community Additions

ADD
Show: