FireDAC encrypted SQLite DB with Delphi 12.3 x64

[Frédéric 0]

Hello,

I'm using a SQLite (aes-128) encrypted database. If I compile the application in 32bit then it works correctly and the database can be opened.
The same application + same database compiled in 64bit generates an AV in FireDACSQliteDriver290.bpl (Read of FFFFFFFFFFFF...).

The database can be opened in the IDE 32bit but same error if I try to open it in the 64bit IDE.

'Engine linkage' is set as slFDEStatic and I have only FireDAC.Phys.SQLiteWrapper.FDEStat unit in the uses.

 

Note: the same non encrypted database can be opened in the 64bit IDE but I have the same problem when starting the application.

 

Is this something known ?

 

Thanks !!!

 

 

[Brian Evans 122]

What version of SQLite are you trying to use under 64-bit? 

 

SQLite dropped support for the method FireDAC was using to provide encryption. 

Read : https://docwiki.embarcadero.com/RADStudio/Athens/en/What's_New#FireDAC_SQLite_Version_Update

 

 

[Uwe Raabe 2147]

According to the unit mentioned, the libraries named sqlite3_fde_x64.obj/sqlite3_fde_x86.obj are used. They come with Delphi and are located in subfolders of $(BDSLIB).