Maybe I'm ignorant, but ...

How would encryption prevent anyone who can read your ini file, to still be able to connect by simply using the same encrypted values for user and password?

regards

The ini file setting would look something like this:

DBPassword=h+ip7OhzSaBK1TmcOo3bMWRJYWyuc6CqcPYBWb7Mkkw=

The CrypterObject encryption functions produce a blob so if your app is updating the ini file password, you need to use CoderObject to convert it into a Base64 string. To decode the string, you would use CoderObject to convert the Base64 string back to a blob and feed that into CrypterObject to get the unencrypted password.

If you are worried about spy software reading app memory, do the conversion in local variables so that the unencrypted value doesn't hang around in memory. Then blank out sqlca properties after the connection is made.

Hi Avory;

  My STD Framework does that as a standard feature. It also decrypts / encrypts the Transaction Object in memory automatically during a "Connect;". It now has a separate App too for managing & changing the INI values for different environments (ie: QA, IT, UAT, Prod, etc.). The feature also allows a unique encryption / decryption key by App.

FYI: https://chrispollach.blogspot.com/2024/05/2024r2.html

  The framework is free & open source. So feel free to either use it "as is" or assimilate the code that you need if you find a feature interesting. HTH 

Regards ... Chris

Hi.

For encryption, you will have to use CrypterObject object. Documentation for:

PB 2019 R3 -> CrypterObject object - - Objects and Controls (appeon.com)

PB 2019 R2 -> CrypterObject object - - Objects and Controls (appeon.com)

PB 2019 -> CrypterObject object - - Objects and Controls (appeon.com)

You want to encrypt all the information included in the ini, or some specific values?

Have you thought what should be the encryption key? You want the encryption to be for each computer, each user or both? Those are some of the questions you should answer. At this point your question is to generic.

Andreas.