On 19 Aug 2012, at 3:38pm, "Lukas Fellechner" <lukas.fellech...@gmx.net> wrote:
> I tried using the WinRT builds of sqlite. But I find there are problems > when using transactions. While my table creation and insert statements work > fine, all transacted "update" statements are failing with result > "CannotOpen", error message is "unable to open database file". This even > happens when the connection is already open and I have already inserted > some lines into the DB. So the file is definately opened and write locked > for SQLite. > > If I replace the sqlite3.dll with the "regular" build, then I do not have > any issues. And if I remove the "begin transaction", then also everything > works fine. Using both versions can you tell us the results of SELECT sqlite_version(),sqlite_source_id() Do you define transactions for your INSERT commands too ? I can think of some reasons to get the error for all transactions. This might be because although your application can access the database file without errors, it has trouble with the journal file in the same folder and the 'cannotopen' error is about the journal file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
