If you encrypt a database this way That what tools to manage the database?

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

If you encrypt a database this way That what tools to manage the database?

Post by devart001 » Wed 23 Apr 2014 08:21

UniConnection.Database := 'C:\sqlite.db3'; // the name of the database to be encrypted
UniConnection.SpecificOptions.Values['ForceCreateDatabase'] := 'False'; // to check that the database exists
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'] := ''; // no encryption key specified, because the database is not encrypted yet
UniConnection.Open; // connect to the database
TLiteUtils.EncryptDatabase(UniConnection, '11111');
--------------------------------------------
如果用这种方式加密了数据库
那用什么工具来管理数据库呢?
If you encrypt a database this way
That what tools to manage the database?

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

Re: If you encrypt a database this way That what tools to manage the database?

Post by AlexP » Wed 23 Apr 2014 11:08

If you are using the Direct mode, you won't be able to open the encrypted database in any third-party utility. If you are using a third-party library with support for encryption, then you will be able to open the database in any utility for work with SQLite using this library.

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

Re: If you encrypt a database this way That what tools to manage the database?

Post by devart001 » Thu 24 Apr 2014 08:22

SQLite Expert Professional 3 will not open database

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

Re: If you encrypt a database this way That what tools to manage the database?

Post by AlexP » Thu 24 Apr 2014 12:09

Please provide a link to the used library

Post Reply