System.Data.SQLite

Hello!

I am creating a new project using SQLlite for the first time..

I have the necessity to encrypt the database but I can't figure out how to manage it.

I saw in the forum that sqllite uses RC4 encryption but encrypting the database file and providing password in the connection string it doen't work.

Is there a way how to do it? thanks in advance.

Regards, Giuseppe

 http://sqlite.phxsoftware.com/forums/t/130.aspx

Hi Nate,

I had a look in that post but it is not exactly what I was asking for.

I created the DB, I connected and then ecrypted using RC4.

When I set the password in the connection string  SQLite throws an error like "not a database"....

I do something like this (because sometimes the database is encrypted, and other times not).

private static void Open()
{
    try
    {
        m_connection.Open();
    }
    catch (SQLiteException ex)
    {
        if (ex.ErrorCode == SQLiteErrorCode.NotADatabase)
        {
            m_connection.SetPassword("your password");
            Open();
        }
        else
        {
            throw;
        }
    }
}

Does this help?