Below is the call to open a new database. This comes back successful. sqlite3_open16(pchFileName, &m_sqliteDB) pchFileName: is the path to the database m_sqliteDB: is the database handler
This function executes a PRAGMA statement. sqlite3_exec(m_sqliteDB, m_formatBuffer, g_sqlCallback, this, &m_sqliteErrMsg); These are the two functions that are called. The open comes back successful, but when the exec is called it returns with a "database is locked" error. > -------Original Message------- > From: Robert Simpson <[EMAIL PROTECTED]> > Subject: Re: [sqlite] "Database is Locked" > Sent: Aug 19 '08 15:16 > > Show and tell time! Lets see some code :) > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, August 19, 2008 8:15 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] "Database is Locked" > > I haven't changed anything. I recompiled with 3.5.7 and it worked fine. Are > there > any problems with creating the database with 3.5.7 and then reading it with > 3.6.1? > > Thanks > > > -------Original Message------- > > From: D. Richard Hipp <[EMAIL PROTECTED]> > > Subject: Re: [sqlite] "Database is Locked" > > Sent: Aug 19 '08 14:38 > > > > > > On Aug 19, 2008, at 10:33 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > > wrote: > > > > > I currently have a project that runs on a Windows XP machine. The > > > project was working with > > > SQLite 3.5.7, but I recently upgraded to 3.6.1 . Since the upgrade I > > > have been getting > > > an "Database is Locked" error message on any type of query that is > > > ran after the database is > > > "opened". I am assuming that when the database is opened it is being > > > locked somehow. I am > > > using sqlite3_open16 to open the database and sqlite3_exec to > > > execute a simple PRAGMA > > > statement. If anyone knows of a solution to this problem I would > > > appreciate the help. > > > > > > > What else have you changed other than 3.5.7 -> 3.6.1? If you pull > > out 3.6.1 and recompile with 3.5.7 again does the problem go away? > > > > I do not recall making any changes to locking behavior between 3.5.7 > > and 3.6.1.... > > > > D. Richard Hipp > >[EMAIL PROTECTED] > > > > > > > > _______________________________________________ > > sqlite-users mailing list > >[EMAIL PROTECTED] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
