I was building the Zend Framework quick start tutorial example but I kept getting the following error:
Message: SQLSTATE[HY000]: General error: 14 unable to open database file
This was despite the fact that I had correct privileges on the database file.
However it turns out you seem to need write and execute privileges for Apache on the directory that contains your sqlite database (not just the database file itself).
I added them to the containing directory and everything seems to work now. 🙂
[Link] (Nabble.com and the original source of this solution)