Page 1 of 1
Why can't I connect to encrypted sqlite database file?
Posted: Wed 01 Jan 2020 17:57
by habipoguz
Hello everyone,
I encrypt my sqlite database file and set its password to 123 as follows.
Code: Select all
var conn = new SQLiteConnection("Data Source=Encrypted.db;Version=3;");
conn.Open();
conn.ChangePassword("123");
I don't get an error when I try to connect to the encrypted sqlite database file as follows. So I think that there is no error in database encryption.
Code: Select all
var conn = new SQLiteConnection("Data Source=Encrypted.db;Password=123");
conn.Open();
I want to create a Devart LinqConnect Model for this database file. I tried two different ways to do this, as I share the screenshots below.
-
How do I create a Devart LinqConnect Model?
Yours truly.
Re: Why can't I connect to encrypted sqlite database file?
Posted: Tue 07 Jan 2020 03:57
by habipoguz
Can you help me, please? I can't go back to the project because I can't do it ...
Re: Why can't I connect to encrypted sqlite database file?
Posted: Thu 09 Jan 2020 20:45
by Shalex
dotConnect for SQLite supports SEE, CEROD, SQLCipher, and SQLiteCrypt encryption extensions.
The Encryption connection string parameter determines the encryption SQLite extension to use. Note that if you want to use encryption mode other than "None" (which means no encryption - the Password value is ignored), you need to buy the corresponding extension separately and compile the SQLite engine with it. For example:
*
https://www.devart.com/dotconnect/sqlit ... ipher.html
*
https://www.devart.com/dotconnect/sqlit ... Crypt.html
Did you replace sqlite3.dll shipped with the provider installation with sqlite3.dll that supports CEROD?
x86 version
* C:\Program Files (x86)\Devart\dotConnect\SQLite\sqlite3.dll
* C:\Windows\SysWOW64\sqlite3.dll
x64 version
* C:\Program Files (x86)\Devart\dotConnect\SQLite\x64\sqlite3.dll
* C:\Windows\System32\sqlite3.dll
Re: Why can't I connect to encrypted sqlite database file?
Posted: Mon 13 Jan 2020 04:35
by habipoguz
Thank you so much. I'm sorry for the late reply. I am currently writing my doctoral dissertation. I'il answer as soon as possible. I hope I don't have a problem.