Click here to Skip to main content
11,583,555 members (66,386 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 390
1 Dave Kreskowiak 230
2 Sergey Alexandrovich Kryukov 210
3 virusstorm 209
4 Richard Deeming 180
0 OriginalGriff 1,523
1 Sergey Alexandrovich Kryukov 995
2 Abhinav S 696
3 Dave Kreskowiak 621
4 Suvendu Shekhar Giri 568


Advertise | Privacy | Mobile
Web04 | 2.8.150603.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