3 Replies - 5775 Views - Last Post: 30 May 2011 - 08:22 AM Rate Topic: -----

#1 blank_program  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 11
  • View blog
  • Posts: 282
  • Joined: 22-July 09

SQLite issue

Posted 27 May 2011 - 06:15 PM

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?
Is This A Good Question/Topic? 0
  • +

Replies To: SQLite issue

#2 Sergio Tapia  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 1253
  • View blog
  • Posts: 4,168
  • Joined: 27-January 10

Re: SQLite issue

Posted 27 May 2011 - 07:23 PM

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

Was This Post Helpful? 0
  • +
  • -

#3 blank_program  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 11
  • View blog
  • Posts: 282
  • Joined: 22-July 09

Re: SQLite issue

Posted 27 May 2011 - 07:47 PM

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?
Was This Post Helpful? 0
  • +
  • -

#4 blank_program  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 11
  • View blog
  • Posts: 282
  • Joined: 22-July 09

Re: SQLite issue

Posted 30 May 2011 - 08:22 AM

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

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1