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
Post a Comment