Database password

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
egrobler
Posts: 29
Joined: Mon 03 Dec 2012 14:35

Database password

Post by egrobler » Thu 08 Jun 2017 13:37

Hi,

I am trying to access a database that was created with the DISQLite3 (www.yunqa.de) library and protected with a password.
The library calls this code when creating a database:

Code: Select all

sqlite3_key(FHandle, Pointer(FPassword), Length(FPassword)));

function sqlite3_key; external;
function sqlite3_key(
  DB: sqlite3_ptr;
  const PKey: PAnsiChar;
  nKey: Integer
  ): Integer;
How can I use LiteDAC to open the database?

Thanks & regards
Eric

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Database password

Post by MaximG » Fri 09 Jun 2017 13:31

LiteDAC components use standard encryption algorithms when working with SQLite DB in Direct Mode: https://www.devart.com/litedac/docs/?da ... yption.htm.
However, implementation of support for these algorithms may vary for each of the access component developers. It is due to the implementation of the encryption mechanism
when using SQLite, we do not support working with databases encrypted with the help of third-party libraries.

Post Reply