System.Data.SQLite

I habe a db which is protected with a password using the .password property of the connectionstrinbuilder. Writing and reading with the ado.net provider ist no problem and works fine but if I try to connect to the db with a GUI tool like SQLite2009 Pro Enterprise Manager it tells me that the file is encrypted but it still wont open after entering the right password. Is there a diference between how the ado.net provider and other providers/tools handle passwords and encrypt databeses?

I'm not familiar with SQLite2009 Pro Enterprise, so I'm not sure how it deals with encrypted databases.

There is an encryption module that Dr. Hipp sells as source code, and then there is the encryption module that I wrote myself and bolted onto SQLite.  If 2009pro is using Dr. Hipp's encryption module, then yes it is incompatible with the one in the ADO.NET provider.

 If you has set a password in your database with SQLite2009 Pro, you must enter md5 value for your password in the ado.net provider

e.g:

You have set password = 'mypassword' for your database that created with SQLite2009 Pro

Now, when you want to connected your .NET application with your database, you must entering '34819d7beeabb9260a5c854bc85b3e44' as encryption password.

You can use md5 function from SQLite2009 Pro to get md5 value from any your text

SELECT md5('test'); -- return md5 hash for test string

I am able to open encrypted database using SQLite2009 Pro with plain password. No need to hash it using MD5.