[blank_program]

So I got a request for an application but it needs to be able to handle the newest version of SQLite which is 3.7.6.3 and http://sqlite.phxsoftware.com/ does not seem to have been updated for it. Does anyone know of any other good libraries for accessing and modifying the database?

[Sergio Tapia]

Probably redundant, but have you seen:
http://system.data.s.../www/index.wiki

This is a fork from the original version you linked that will be the main 'fork' from here on out.

Yep, it supports what you want:
http://system.data.s.../downloads.wiki

This post has been edited by Sergio Tapia: 27 May 2011 - 07:24 PM

[blank_program]

I am assuming that I need the x86 version if that is what I will be deploying on rather then x64 that I am coding on?

[blank_program]

I copied over the x86 assemblies from system.Data.Sqlite to my project and referenced them correctly. If I target x86 platforms I get an exception stating "An attempt was made to load a program with an incorrect format" and when I target AnyCPU the application hangs when I open my SQlite connection.

Here is my connection string:

        internal void ReadDatabase()
        {
            try
            {
                SQLiteConnection conn = new SQLiteConnection();
                conn.ConnectionString = "Data Source=" + FilePath + ";Version=3;New=False;";
                conn.Open();

                Console.WriteLine("Database opened successfully.");

                conn.Close();
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }

The FilePath does reference a valid path and file and I can view the database from other applications. Any idea what is going on? I think the target system will be 32bit but I am working on a x64 version of Windows if that matters at all.

Edit: If it matters the database I am trying to work with is for Firefox 3 and 4 and its the bookmarks database.

This post has been edited by blank_program: 30 May 2011 - 08:28 AM