SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Native Client Programming

SQL Server Native Client (OLE DB)

Creating a SQL Server Native Client OLE DB Provider Application

Establishing a Connection to a Data Source

Executing a Command

Processing Results

About OLE DB Properties

Using the OUTPUT Clause with OLE DB in SQL Server Native Client

Minimize

This topic has not yet been rated - Rate this topic

Creating a SQL Server Native Client OLE DB Provider Application

SQL Server 2012

Creating a SQL Server Native Client OLE DB provider 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

Concepts

SQL Server Native Client (OLE DB)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.