Has anyone work with the always encrypted functions of MS SQL from Clarion?
We have several “always encrypted” columns and if we set
Column Encryption Setting=enabled
as additional parameted in Microsoft SQL Server Management Studio when connect to the server and then do
select * from MyTable
we see all encrypted columns info as a normal text.
So when we run our Clarion 10 application and try to open our MyTable (in browse window) we are getting error (because of encrypted columns).
Anyone know how to work with encrypted (in MS SQL server) columns from Clarion? Any idea?
What should be connection string? Any specific settings for the fields in clarion dct?
This is because of the new EU regulation forces us to encrypt the data (GDPR).