>>>>I need to implement in my VFP application being converted to SQL Server backend a Password feature. Currently in the VFP application I have a table MyPasswords.dbf that has (simplified) two column USER_NAME (C(20)) PASS_STR (C(200)). The PASS_STR contains a string like this “YNYNNNY” (just bunch of Y and N) encrypted using a very basic algorithm (which I created so it can be cracked in about 20 seconds <g>). But the application does not need much of security so it works.
>>>>I can basically duplicate the same approach with a SQL Server table but before I do I thought I would ask if SQL Server has a simple (emphasize SIMPLE) way to encrypt a table and un-encrypt it in VFP application?
>>>>
>>>>TIA.
>>>
>>>Check HashBytes function in SQL Server.
>>>
>>>See
http://wiki.lessthandot.com/index.php/Generating_a_MD2,_MD4,_MD5,_SHA,_or_SHA1_hash_by_using_HashBytes>>
>>Thanks.
>
>If you want to Encrypt the data, not Hash the data, start from this page
>
http://technet.microsoft.com/en-us/library/bb510663.aspx and follow all the links.
Thank you. But I am thinking of using the encryption program from Craig Boyd; I have use it in another place and it worked perfectly.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham