Ok, finally I found the problem is that the PHP and Apache are installed in
local drive and I put the sqlite database file on a remote file server which
is a Linux / Samba. I can use sqlite3.exe to open that remote database with
a mapped remote drive. And Insert, Update and Delete have no problem with
it. While with Apache and PHP pdo, if the database is concurrently opened by
sqlite3.exe, it will report "can't not open database". Close sqlite3.exe,
then PHP pdo can open it, but it open as read-only. If I put the database
file in local dirve, then there is no any problem at all. Even I can use
sqlite3.exe concurrently with PHP pdo. Does Apache has different thinking
about remote server?
Jack
----- Original Message -----
From: "DJ Anubis" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, June 02, 2006 12:13 AM
Subject: Re: [sqlite] question about php_pdo_sqlite
yuyen wrote:
And the error message is:
"execute err: SQLSTATE[HY000]: General error: 8 attempt to write a
readonly database"
So the problem is why the database becomes read only.
This time, you get another message :)
Are you sure the Web Server user (Apache or...) has write access to your
sqlite database file ?
