How To

Re: Encrypting, decrypting and attaching to encrypted databases

flater — Tue, 05 Jan 2010 10:25:53 GMT

Solved it by using:

conn.ChangePassword(null as String);

this will choose the right method.

Re: Encrypting, decrypting and attaching to encrypted databases

flater — Mon, 04 Jan 2010 15:03:55 GMT

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

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

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!

Re: Encrypting, decrypting and attaching to encrypted databases

Prachi — Wed, 23 Sep 2009 13:10:26 GMT

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 ?

Re: Encrypting, decrypting and attaching to encrypted databases

ammsamm — Fri, 11 Jul 2008 03:54:42 GMT

Hi all....

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

hop u find it useful

Re: Encrypting, decrypting and attaching to encrypted databases

Seth — Thu, 10 Jul 2008 16:45:23 GMT

Thanks

Re: Encrypting, decrypting and attaching to encrypted databases

Robert Simpson — Thu, 10 Jul 2008 06:05:00 GMT

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.

Re: Encrypting, decrypting and attaching to encrypted databases

Seth — Sun, 06 Jul 2008 08:04:22 GMT

Hi,

So the enryption is a good protection for the data ?

Re: Encrypting, decrypting and attaching to encrypted databases

Robert Simpson — Sun, 06 Jul 2008 01:48:44 GMT

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

Re: Encrypting, decrypting and attaching to encrypted databases

ammsamm — Sat, 05 Jul 2008 22:14:49 GMT

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 ??

Re: Encrypting, decrypting and attaching to encrypted databases

Robert Simpson — Tue, 01 Jul 2008 02:29:16 GMT

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.

Re: Encrypting, decrypting and attaching to encrypted databases

ammsamm — Tue, 01 Jul 2008 00:31:33 GMT

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

Re: Encrypting, decrypting and attaching to encrypted databases

ammsamm — Tue, 01 Jul 2008 00:10:33 GMT

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

Re: Encrypting, decrypting and attaching to encrypted databases

Robert Simpson — Mon, 30 Jun 2008 23:59:54 GMT

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.

Re: Encrypting, decrypting and attaching to encrypted databases

ammsamm — Mon, 30 Jun 2008 23:52:29 GMT

Dim cnn As New SQLiteConnection("Data Source=" & TextBox1.Text)

cnn.Open()

' Encrypts the database. The connection remains valid and usable afterwards.

cnn.ChangePassword(Me.TextBox2.Text)

cnn.Close()

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

is it possible to give a msg to confirm that the password have change ??

am using vb.net

Re: Encrypting, decrypting and attaching to encrypted databases

Seth — Sun, 15 Jun 2008 12:45:23 GMT

Hi,

Encryption it is a good way to protect data ? or the enryption method is not enough ?

thx