Re: [sqlite] SQLite and Virtual PC
> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Gintaras Didzgalvis > Sent: zondag 8 september 2013 06:32 > To: sqlite-users@sqlite.org > Subject: [sqlite] SQLite and Virtual PC > > Hi, > > SQLite running on Microsoft Virtual PC 2007 cannot read and write > databases that are on host PC. > > Details: > sqlite3_open_v2(SQLITE_OPEN_READWRITE) succeeds, but sqlite3_exec > returns SQLITE_BUSY, even with SELECT. > Using the official downloaded sqlite3.dll, version 3.8.0. > OS on guest PC, where SQLite is used: Windows XP, SP3. > OS on host PC: Windows 7, 32-bit. > Accessing the database file using the "shared folders" feature of > Virtual PC. > Windows API functions can read and write the file. > No problems on Vmware player (accessing the file through its virtual > network). The Virtual PC shared folder feature implements only a very tiny subset of the filesystem apis and I don't think Microsoft will support this for adding new features. I would recommend using a shared drive over the virtual network from Virtual PC too, as that should work just like fileshares between machines (and is a well tested scenario by both Microsoft as well as many Sqlite based application users) Bert > > -- > -- > > Gintaras > http://www.quickmacros.com > __ > > ___ > 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
Re: [sqlite] SQLite and Virtual PC
Hello Stephen, My experience is that shared folders under Virtual PC are completely unreliable. SMB actually works better, other than the fact Sqlite doesn't seem to like SMB. C Sunday, September 8, 2013, 4:46:04 PM, you wrote: SC> You're using it via a network which is a no-no for SQLite. ANY remote SC> access of a file under any networking infrastructure isn't guaranteed with SC> SQLite. SC> On Sun, Sep 8, 2013 at 12:31 AM, Gintaras Didzgalvis < SC> supp...@quickmacros.com> wrote: >> Hi, >> >> SQLite running on Microsoft Virtual PC 2007 cannot read and write >> databases that are on host PC. >> >> Details: >> sqlite3_open_v2(SQLITE_OPEN_**READWRITE) succeeds, but sqlite3_exec >> returns SQLITE_BUSY, even with SELECT. >> Using the official downloaded sqlite3.dll, version 3.8.0. >> OS on guest PC, where SQLite is used: Windows XP, SP3. >> OS on host PC: Windows 7, 32-bit. >> Accessing the database file using the "shared folders" feature of Virtual >> PC. >> Windows API functions can read and write the file. >> No problems on Vmware player (accessing the file through its virtual >> network). >> >> -- >> -- >> >> Gintaras >> http://www.quickmacros.com >> __ >> >> __**_ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> SC> ___ SC> sqlite-users mailing list SC> sqlite-users@sqlite.org SC> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Tegmailto:t...@djii.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite and Virtual PC
You're using it via a network which is a no-no for SQLite. ANY remote access of a file under any networking infrastructure isn't guaranteed with SQLite. On Sun, Sep 8, 2013 at 12:31 AM, Gintaras Didzgalvis < supp...@quickmacros.com> wrote: > Hi, > > SQLite running on Microsoft Virtual PC 2007 cannot read and write > databases that are on host PC. > > Details: > sqlite3_open_v2(SQLITE_OPEN_**READWRITE) succeeds, but sqlite3_exec > returns SQLITE_BUSY, even with SELECT. > Using the official downloaded sqlite3.dll, version 3.8.0. > OS on guest PC, where SQLite is used: Windows XP, SP3. > OS on host PC: Windows 7, 32-bit. > Accessing the database file using the "shared folders" feature of Virtual > PC. > Windows API functions can read and write the file. > No problems on Vmware player (accessing the file through its virtual > network). > > -- > -- > > Gintaras > http://www.quickmacros.com > __ > > __**_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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] SQLite and Virtual PC
Hi, SQLite running on Microsoft Virtual PC 2007 cannot read and write databases that are on host PC. Details: sqlite3_open_v2(SQLITE_OPEN_READWRITE) succeeds, but sqlite3_exec returns SQLITE_BUSY, even with SELECT. Using the official downloaded sqlite3.dll, version 3.8.0. OS on guest PC, where SQLite is used: Windows XP, SP3. OS on host PC: Windows 7, 32-bit. Accessing the database file using the "shared folders" feature of Virtual PC. Windows API functions can read and write the file. No problems on Vmware player (accessing the file through its virtual network). -- -- Gintaras http://www.quickmacros.com __ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users