Page 1 of 1

Database password

Posted: Thu 08 Jun 2017 13:37
by egrobler
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

Re: Database password

Posted: Fri 09 Jun 2017 13:31
by MaximG
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.