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