July 21, 2010 at 8:44 am
I am working on a task to encrypt two fields in two tables...Okay so I can use Symmetric Keys and a Certificate...that all works great, but my client interface is using ADO for all updates. Is there an ADO class that will work with SQL encryption do encrypt only one field during an update?
-chris
July 21, 2010 at 9:33 am
How about performing the update through a stored proc and then you can encrypt the data going into the database? You can also decrypt as necessary on the retrieval through a proc as well.
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 21, 2010 at 9:44 am
Yeah...I know that would be simple...but the application uses ADO for ALL updates and passes the control through a generic base class...ugh.
-chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply