System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: 23e3a08814d71621937e8d6ef7738e2cea73f0ca
Title: Cannot open database with password in any editor
Status: Closed Type: Question
Severity: Important Priority: Medium
Subsystem: Legacy_CryptoAPI Resolution: Out_Of_Community_Support
Last Modified: 2019-12-17 01:59:51
Version Found In: 1.0.112
User Comments:
anonymous added on 2019-12-16 04:40:00:

Hi, I've created a sqlite database file with password using the method SetPassword() and the database created successfully, but the problem is that i want to open the database file in any sqlite editor and i can't, Not all editors support system.data.sqlite only SQLiteStudio do , but sadly i get an error when trying to do that with SQLiteStudio and databse type is system.data.sqlite.

If you can direct me to the right direction i will much appreciate it.

Thanks in advance


mistachkin added on 2019-12-17 01:59:51:
The CryptoAPI-based encryption included with System.Data.SQLite is a
legacy feature, has known issues, and is officially unsupported.  It is
being retained only for the purpose of backward compatibility with legacy
applications that make use of it.

Alternatively, you might want to look into the commercial SEE extension,
which does work with System.Data.SQLite and is fully supported for use
with it.