System.Data.SQLite

Give a message where?  If you want to pop open a message box on the screen, that's up to you.  The provider itself has no user interface -- nor should it.

ya i wona popup a message box >>> the resone is that the (ChangePassword ) dont give a value

Sorry >>>>>> ya i wona popup a message box >>> the resone is that the (ChangePassword ) dont produce a value

Sorry the SQLite data provider is not a UI component and I cannot put a message box up on the screen.  If the provider fails to change the password or an error occurs, it'll be thrown as an exception for you to catch.

This provider is used in ASP.NET, windows services, and other components that do not interact with the desktop.  Popping up a message box when that function is called is not an option.

well .. i manege to popup a msg box after closing the connection, although thats not what wont bute it will do the job.

Thanks

------------------------------------

one more thing ............. is it possible to check if the db is password protected before throwing an exception ??

Unfortunately the entire file, including all metadata is encrypted ... without a password, the sqlite engine can't even tell if its a sqlite database.

 

 Hi,

 

So the enryption is a good protection for the data ?

It's reasonably good.  It's an RC4 algorithm, which is weaker than some, but not as weak as others.  Remember that nothing stored on a user's machine is ever truly secure.

 

 Thanks

Hi all....

i did a small app for encrypting, decrypting and compressing a sqlite database

hop u find it useful

CAn anyone give me a small sample code in .NET which connects to encrypted database ( Password set to database) and opens connection. I tried above code but it gives me error :- " File opened that is not a database file file is encrypted or is not a database " How the connection string should be passed and how to decrypt the database which is encrypted ?

 In the original example, you say you can decrypt a database by supplying the following command:

 </p><p>conn.ChangePassword(null);</p><p>&nbsp;

But when I try this, it doesn't work because it is an ambiguous call. Besides the (string) argument there is 1 overload with a byte[ argument on this method, which causes this.

 

Please advise how to continue!

Solved it by using:

 conn.ChangePassword(null as String);

 this will choose the right method.

I'm using Visual Basic 2008 and aslo get error. Solved it by using:

</p><p>conn.ChangePassword(System.DBNull.Value.ToString)
</p><p>

I have successfully encrypted database using password. I have also download SQLite2009 Pro to open encrypted database. This tools asks for password and opens database. But, it  uses my password to decrypt the database. So, I cannot ensure that the database data is encrypted (as data is automatically decrypted). I cannot see encyrpted data (I know this is what we want).

But, How can I ensure that encryption is performed correctly.