Encryption Questions

I have written two Functions one for encryption and one for Decryption (using _crypt.vcx), I would like to encrypt all data in my app . I have a few Questions…
1) When creating my tables what do I use for datatypes
2) What about indexing Do I index on Decypt(field1).
3)
What about SQL Do I do Select Decypt(field1), Decypt(field2)…
4)
What about select * .

Is it supposed to be this big of a pain or am I just going off in wrong direction
Thanks,
Sammy



Answer this question

Encryption Questions

  • Pramod Gurunath - MSFT

    >I’m sure there is a better way of doing this.

    The better way is to get Cryptor from Xitech that does it for you automatically behind the scenes.

    http://www.xitech-europe.co.uk/Cryptor.html
    http://www.hallogram.com/cryptor/
    http://fox.wikis.com/wc.dll Wiki~Cryptor

     


  • Kevin Mullican

    Sammy's correct. 100 runtime licenses means you can distribute code using Cryptor to up to 100 machines. If you need more, you buy additional licenses.

    Tamar

  • Wolfey305

    It means that you can only encrypt\decrypt your data 100 times, and then you have to buy new licenses…

    JK..

    I was afraid that this was what it meant....... So I wanted semantic clarity. Some websites are really weird. People selling their wares do not bother making their purpose clear in this business. When you walk into a shoe store you know that you won't find a bunch of hats in there. What does "runtime" have to do with a machine Another example: software called Kryptos. No explanation as to what it does whatsoever. I thought it was out of cryptology but does not seem to be the case inferring from GUI they show.



  • Antonionini

    I personally had such ideas fleetingly long time ago and abandoned them as impractical. You will be losing a lot of time in terms of execution and extra coding. Also if you are starting from scratch you will need a lot of visual control for a while. You will have to open some of your tables in a browser to see if the right data is there, if a field has been changed correctly.

    What I do now is to encode ids and passwords only in a couple of tables. They are rather short. I may also encode some of the memo fields selectively, perhaps.

    In old dBase IV there was an option to have all tables encoded if you turned a switch on. I doubt anybody ever used it.



  • DerekLakin

    For programming I will have to sets of data, one encrypted and one not.

    I also will have a global variable specifying witch data path to use, that same variable will be used in my encrypt \ decrypt functions. Is if I am using non-encrypted data the encrypt \ decrypt will just return what ever is passed in.

    I just feel that basic things like binding a textbox to a data field become a big pain.

    I’m sure there is a better way of doing this.

    Thanks
    Sammy.


  • igloo iguana

    It means that you can only encrypt\decrypt your data 100 times, and then you have to buy new licenses…

    JK..

    I think it means that if you are distribution your software, packaged with there tool, you can distribute it 100 times. Or buy more licenses.

    Sammy


  • Alan Cameron Wills

    What does it mean to purchase a license with 100 runtimes: "Includes 100 runtime license " Additional 1000 runtimes

  • Encryption Questions