无法访问SQLite数据库（火狐）使用System.Data.Sqlite火狐、无法访问、数据库、SQLite

2023-09-03 05:29:33 作者：开岸。

我写了一个小的C＃/。应用网络，能够读取的Firefox cookies.sqlite文件。自从我升级到Firefox 4我的应用程序无法打开数据库文件：

I wrote a small C#/.Net application that is able to read the cookies.sqlite file of Firefox. Since I upgraded to Firefox 4 my application is not able to open the database file:

执行行connection.Open（）; （在code下面的示例中）将会有一个execption，上面写着：

Executing the line "connection.Open();" (in the code sample below) there will be an execption that says:

打开的文件不是数据库文件。文件加密或不是一个数据库

"File opened that is not a database file. file is encrypted or is not a database"

这是我的程序code：

This is my program code:

class Program
{
    static void Main()
    {

        const string PATH_TO_DATABASE = @"C:\Users\Boris\Desktop\TEMP\cookies.sqlite";
        const string CONNECTION_STRING = @"Data Source=" + PATH_TO_DATABASE;

        if (!File.Exists(PATH_TO_DATABASE)) return;

        using (SQLiteConnection connection = new SQLiteConnection(CONNECTION_STRING))
        {
            connection.Open();
            using (SQLiteCommand command = new SQLiteCommand("SELECT id, name, host, path FROM moz_cookies", connection))
            {
                using (SQLiteDataReader read = command.ExecuteReader())
                {
                    while (read.Read())
                    {
                        string id = read[0].ToString();
                        string name = read[1].ToString();
                        string host = read[2].ToString();
                        string path = read[3].ToString();
                        Console.WriteLine("ID: " + id);
                        Console.WriteLine("Name: " + name);
                        Console.WriteLine("Host: " + host);
                        Console.WriteLine("Path: " + path);
                    }
                }
            }
        }
    }
}

我现在用的是NET包装DLL SQLite的诉3.6.23.1。该应用程序的目标框架NET 2.0。

I am using the .Net Wrapper DLL for Sqlite v. 3.6.23.1. The target framework of the application is .Net 2.0.

我可以不使用所谓的SqliteExpert的应用程序的任何问题打开SQLite数据库。

I was able to open the sqlite database without any problems using an application called SqliteExpert.

这将是巨大的，如果任何人有一个想法！

It would be great if anybody has an idea!

问候，鲍里斯