How to Use Trusted Connection in OLE DB Provider

This article tells us about connection string used to create trusted connection.
  • 2220

Introduction

Trusted connection is similar to Windows authentication. To create connection string  with trusted connection in SQL server native client 10.0 OLE DB provider we need to put provider, your server address, your database name, set the state of Trusted connection to true.

Syntax

Provider=SQLNCLI10;Server=urServerAddress;Database=urDataBase; Trusted_Connection=yes;

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answers here

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.