We have to use SQL 2000 for storing electronic votes as our final year project. We must use encryption and provide maximum security in our back-end SQL 2000 system. Is it possible since this server is 10 years old technology?
Answer by easyire · May 11, 2010 at 08:19 AM
It is old but not obsolete technology. It can be done but you need to research on System.Security.Cryptography in .net. Learn up binary, var binary, or image data type. Alternatively, convert bytes to a base 64 encoded string in .net and save as var char field.
You need to encrypt and decrypt the data using code.