Tool with SQLite Expert Professional 3 can still open

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
devart001
Posts: 23
Joined: Wed 02 Apr 2014 09:13

Tool with SQLite Expert Professional 3 can still open

Post by devart001 » Wed 23 Apr 2014 08:20

UniConnection.Database : = 'C:\sqlite_encoded.db3'; // the name of the database to be created
UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'True'; // this will allow to create the new database
UniConnection.SpecificOptions.Values['Direct'] := 'True'; // database file encryption is supported in the Direct mode only
UniConnection.SpecificOptions.Values['EncryptionAlgorithm'] := 'leBlowfish'; // the database will be encrypted with the Blowfish encryption algorithm
UniConnection.SpecificOptions.Values['EncryptionKey'] := '11111'; // the encryption key for the database
UniConnection.Open;
--------------------
用 SQLite Expert Professional 3 工具还是能打开啊,
Tool with SQLite Expert Professional 3 can still open
根本不需要秘码
Do not need a password

why ??

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Tool with SQLite Expert Professional 3 can still open

Post by AlexP » Wed 23 Apr 2014 10:52

Hello,

Until at least one table is created in the database, the header is not created (the database file's size is 0). Therefore the database is not encrypted yet. After opening the database, create a table, insert data into it - after this, you won't be able to open the DB in any third-party utility.

devart001
Posts: 23
Joined: Wed 02 Apr 2014 09:13

Re: Tool with SQLite Expert Professional 3 can still open

Post by devart001 » Thu 24 Apr 2014 08:24

ok,thank you.

Post Reply