How to resolve "The database file is locked database is locked" in Sqlite

Question

4.00/5 (1 vote)

See more:

I am using following code in window 7.
i want to get my google chrome history. i am using following code

C#

private void button1_Click(object sender, EventArgs e)
        {
            label1.Text = "Google crome";
            string Google = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\\Google\\Chrome\\User Data\\Default\\History";
            SQLiteConnection cn = new SQLiteConnection("Data Source=" + Google + ";Version=3;New=False;Compress=True;");
            cn.Open();
            SQLiteDataAdapter DA = new SQLiteDataAdapter("select url,title,visit_count,last_visit_time from urls order by last_visit_time desc",cn);
            DataSet ds = new DataSet();
            DA.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            cn.Close();
        }

on button but it give

C#

"The database file is locked database is locked" error..

how we can resolve it plese help me.........

Posted 22-Apr-14 2:23am

osmo33

Updated 12-Dec-20 5:50am

Sampath Lokuge

v3

Add a Solution

Comments

[no name] 22-Apr-14 8:25am

http://www.google.com/search?q=The+database+file+is+locked+database+is+locked

ZurdoDev 22-Apr-14 9:50am

close Chrome.

Member 11692192 10-Jun-15 6:44am

I have the same issue can you please elaborate

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-04-22T02:58:00

you only have folder path

string Google = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\\Google\\Chrome\\User Data\\Default\\History";

when you set Data Source you need to give database file path like Data Source=c:\mydb.db;

close the connection each time after you're finished with it. you can use USING blocks
e.g:

C#

using (SQLiteConnection conn = new SQLiteConnection(connectionString))
{
   conn.Open();  
  // do something with your connection 
}

Member 7722705 · Answer 2 · 2015-04-09T02:56:00

Solution 2

To solve this just copy "History" file to other, "History.1" for exemple. And open it with sqlite function.

Posted 9-Apr-15 2:56am

Member 7722705

How to resolve "The database file is locked database is locked" in Sqlite

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to resolve "The database file is locked database is locked" in Sqlite

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us