Hi there,
is it possible to protect a SQLite - DB with password with dotConnect universal?
Many thanks for your support.
Password protect SQLite DB
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Password protect SQLite DB
SQLite source does not provide password protection in its usual sqlite3.dll engine. However, you can use encryption extensions and encrypt your SQLite database and protect it with password.
dotConnect for SQLite (and dotConnect Universal) supports the following kinds of encryption: SEE, CEROD, SQLiteCrypt and SQLCipher. But you have to purchase the respective SQLite extension, because our provider works with SEE, CEROD, SQLiteCrypt and SQLCipher encryption only if you have the corresponding extension. For more information, please refer to http://www.devart.com/dotconnect/sqlite ... nMode.html
Please note that dotConnect Universal uses common ADO.NET features and does not use specific features of the providers. For example UniConnection does not have the ChangePassword method and you won't be able to change a password or encrypt an unencrypted database with an encryption in dotConnect Universal. For this you need to use dotConnect for SQLite. However, you can specify in connection string needed parameters to connect to a database with dotConnect Universal and connect and work with SEE, CEROD, SQLiteCrypt or SQLCipher database.
dotConnect for SQLite (and dotConnect Universal) supports the following kinds of encryption: SEE, CEROD, SQLiteCrypt and SQLCipher. But you have to purchase the respective SQLite extension, because our provider works with SEE, CEROD, SQLiteCrypt and SQLCipher encryption only if you have the corresponding extension. For more information, please refer to http://www.devart.com/dotconnect/sqlite ... nMode.html
Please note that dotConnect Universal uses common ADO.NET features and does not use specific features of the providers. For example UniConnection does not have the ChangePassword method and you won't be able to change a password or encrypt an unencrypted database with an encryption in dotConnect Universal. For this you need to use dotConnect for SQLite. However, you can specify in connection string needed parameters to connect to a database with dotConnect Universal and connect and work with SEE, CEROD, SQLiteCrypt or SQLCipher database.
Re: Password protect SQLite DB
Hi. If you missed my post on a similar issue, please see it:
viewtopic.php?f=4&t=37035
And, there is an excellent modern freeware SEE-compatible SQLite encryption library named SQLite3MultipleCiphers available here:
https://github.com/utelle/SQLite3MultipleCiphers
I'm using it with dotConnect for an application -- works well.
Good luck.
-C
viewtopic.php?f=4&t=37035
And, there is an excellent modern freeware SEE-compatible SQLite encryption library named SQLite3MultipleCiphers available here:
https://github.com/utelle/SQLite3MultipleCiphers
I'm using it with dotConnect for an application -- works well.
Good luck.
-C