Click here to Skip to main content
11,706,639 members (31,239 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Sqlite
Hi

While I am Upload Data I Got Error like that"The database file is locked
database is locked"
.I'm using SQLite database.I'm not able to upload the data . But in Windows XP it working fine . In Windows 7 it showing error like that

Regards
K.Karthick
Posted 5-Jun-12 1:09am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Read about the details of the error here: Documentation: Error Code SQLITE_LOCKED (6): Database Is Locked[^]

Similar issues discussed here:
http://www.mojoportal.com/Forums/Thread.aspx?pageid=5&mid=34&ItemID=2&thread=7676&pagenumber=1[^]
http://stackoverflow.com/questions/151026/how-do-i-unlock-a-sqlite-database[^]

Based on what I read, it looks like you need to make sure that every connection opened needs to be closed as soon they are no more needed. Debug and see the flow, and open/close connection based on need.
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 146
1 Sergey Alexandrovich Kryukov 140
2 chainerlt 110
3 Mika Wendelius 80
4 ppolymorphe 71
0 OriginalGriff 9,190
1 Sergey Alexandrovich Kryukov 8,407
2 CPallini 5,189
3 Maciej Los 4,756
4 Mika Wendelius 3,686


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 5 Jun 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100