c# - Get data from encrypted sqlite database using sqlite3.exe -


i have password protected database have created using system.data.sqlite.dll in .net windows application.

now want write script fetch data database using sqlite3.exe. how provide password using sqlite3.exe , data database? if directly use select command, throws error: "error: file encrypted or not database"

after opening database via sqlite.exe, use pragma key before issuing additional select/etc. statements:

pragma key="mypassword"; 

edit: looks system.data.sqlite.dll not use semi-standard encryption code found in many sqlite binaries. instead, uses windows crypto apis. the above answer not work.


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -