I have a SQLite database and I was able to set a password from C #.
_connection.ChangePassword("test");
and then I connect like:
_connection = new SQLiteConnection("Data Source=" + Properties.Settings.Default.ConnectionString +
"example.db;Version=3;Max Pool Size=2;Password=test;");
Now my problem is that I want to have a GUI management tool to manage the database file. I am using navicat for SQLite, but I cannot connect to the secure database file.
The error I encountered is "26 - the file is encrypted or is not a database"
Is there any other management program or what am I doing wrong?
source
share