Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET Sqlite
Hi,
 
I've developed a windows application which runs on a sqlite database. I'm packaging that .db file with installer. But i want that this .db file should not be opened by any sqlite editor like SqliteAdmin etc.. ANy idea how to do this??
 

Thank you
Posted 18-Aug-12 8:18am
DEB4u589
Comments
Kenneth Haugland at 18-Aug-12 14:31pm
   
Cant you set it password protected? and encrypt the data?
DEB4u at 19-Aug-12 3:44am
   
password protected
Sergey Alexandrovich Kryukov at 18-Aug-12 14:33pm
   
Does it mean that you are not using it as a server? You need to explain who are you protecting it from. If there is a key to decrypt it to serve data, anyone who can get the key can decrypt it too. So, any realistic scenario?
--SA

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
DEB4u at 19-Aug-12 3:47am
   
it worked for setting the database password :
conn = New SQLiteConnection()
conn.ChangePassword("password")
..
 
It sets the password.. but how to remove the password?
Mehdi Gholam at 19-Aug-12 4:33am
   
Usually you open another db without password then copy the data over.
cynik40 at 19-Nov-13 10:36am
   
"It sets the password.. but how to remove the password?"
 
conn = New SQLiteConnection() conn.ChangePassword("sPassword")
 
(Spassword = string.empty)
 
or conn = New SQLiteConnection() conn.ChangePassword("")

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 6,696
1 Sergey Alexandrovich Kryukov 6,675
2 CPallini 5,315
3 George Jonsson 3,584
4 Gihan Liyanage 2,650


Advertise | Privacy | Mobile
Web03 | 2.8.140921.1 | Last Updated 18 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100