How to Use Data Encryption in OLE DB Provider

In this article I am going to explain about how to use encrypt data sent over network in SQL server native client 10.0 OLE DB provider.
  • 4003

Introduction

Here I am explaining  how to use encrypt data sent over network in SQL server native client 10.0 OLE DB provider.

Data Encryption

To create connection string which encrypt data sent over network 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 and encrypt to true.

Syntax:

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

Further Readings

You may also want to read these related articles :

Ask Your Question 

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

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.