Let me start by saying I have an apps that is wrote in classic asp and with a SQL 2005 back end. I have found this (http://rodsdot.com/asp/AES-Encryption-Using-ASP.as...) that shows how to encrypt data on the asp side and then the encrypted value is then stored in the DB.
I have a few questions for you though. Is this the best way to encrypt? Would it be better to use SQL Column encryption (if so does anyone know how to do this?)???
I was trying to follow this (http://www.4guysfromrolla.com/articles/022807-1.as...) but I don't know asp.net so got lost at the point that they made the .net page and couldn't figure out how to do the same in ASP. I think I would prefer this method as I would then be able to query the db and decrypt at the time of the query, which I would not be able to do in the above ASP encryption example.
Any help/advice/pointers will be greatly appreciated.