Devart Forums

Posted: **Tue 08 Oct 2019 00:16**

Hi

I encrypt my sqlite database using Delphi sample application to encrypted the file but now I am trying to open the database using unidac uniconnect1 and I set the encryption key in the option tab but I get this error when I try to connect:

Code: Select all

---------------------------
Error
---------------------------
SQLite DLL that you are using does not support SQLite database encryption. 
Please download a new DLL or recompile the existing one with encryption support. .
---------------------------
OK   Details >>   
---------------------------

How to fix this ?

Posted: **Tue 08 Oct 2019 11:37**

Encryption does only work in direct mode. Set uniconnection1.SpecificOptions.Values['Direct'] = 'true'.

Posted: **Tue 08 Oct 2019 19:13**

When I specify "leAES128" for encryption algrithms I get "not a database file" and if I used "leDefault" I get

---------------------------
Error
---------------------------
The EncryptionKey property must be empty when no encryption algorithm specified.
---------------------------
OK Details >>
---------------------------

Posted: **Wed 09 Oct 2019 06:54**

Did you encrypt using unidac? Problem is, there is no standard encryption of SQLite. FireDAC has its own Unidac has its own, DISQLITE has its own. So to decrypt a SQLite database you have to use the exact same components you used to encrypt.

Posted: **Wed 09 Oct 2019 15:14**

I encrypted with sqlite maestro . how I can encrypt with unidac ?

Posted: **Thu 10 Oct 2019 13:07**

see here: https://www.devart.com/unidac/docs/data ... yption.htm

Posted: **Thu 10 Oct 2019 16:46**

Wow many thanks frickler
I can connect now !!

Devart Forums

SQLite encryption

SQLite encryption

Re: SQLite encryption

Re: SQLite encryption

Re: SQLite encryption

Re: SQLite encryption

Re: SQLite encryption

Re: SQLite encryption