System.Data.SQLite

Hi,

I have no problems creating a new DB with a password or changing the password afterwards using System.Data.SQLite in my application. I also can open the encrypted DB in my program with the appropriate connection string or using the function SetPassword. My only problem is, that I can't open the created DB using a SQLite-GUI-Front-end. I tried "Mike T's SQLite Database Administrator Tool" (http://saxmike.com) and the "SQLite2008 Pro" (http://osenxpsuite.net), both"recognize" the DB as encrypt but if I enter the password both programs can't open the DB. I only can connect to the DBs with my password using System.Data.SQLite from within my program.

Is this behaviour known (e.g. does every program use their own and that for another encryption method than System.Data.SQLite) or am I missing something?

Here the code I use to connect to the (with System.Data.SQLite) encrypted DB:
SQLiteConnectionStringBuilder conStringBuilder = new SQLiteConnectionStringBuilder();
conStringBuilder["Data Source"] = "path to my db";
conStringBuilder["Password"] = "myPassword";
m_Con = new SQLiteConnection(m_conStringBuilder.ConnectionString);
m_Con.Open();

As I mentioned this works OK, the DB is opened and can be accessed, but I can't open the DB file from another SQLite-GUI using "myPassword".

If this behaviour is known and a fact, could someone recommend another free Administration-GUI for SQLite that works with my created DBs?

Thanks for your help

 Maik

Anyone? I have the same problem, it's definitely some sort of bug in the wrapper. I can't open database files encrypted with System.Data.SQLite in any other SQLite administration tool (I tried 5 of them). Removing the password (through ChangePassword in C#) will make the file readeable again...

That's because the encryption module was written into the SQLite .NET provider.  By default, most 3rd party applications are using the default sqlite3.dll as their back-end, which doesn't support encryption.