Hi, all!
My webserver is running xampp/PHP 5.1.4. I am trying to access an
existing sqlite3 database from my php script using the PDO(PHP Data
Objects) class. I can connect to the DB. I can also create new DBs and
work with them without any problems. However, when I send my query to
this one DB it returns the error: "HY000 unsupported file format".
In the official php forum there is this user contributed note:
"07-Jul-2006 01:41
Note that as of the date of this post, PDO_SQLITE will not interact with
database files created with the current version of the SQLite console
application, sqlite-3.3.6.
It is currently necessary to obtain version 3.2.8"
I don't know for sure which software was used to create the DB but it
could have been sqlite 3.3.6. Importing the DB from mysql 3.2.8 console
client doesn't work because the DB uses some advanced things like
triggers. My question is now if there is any possibility to access a
sqlite3 database from a web server without using the official PDO
classes. Of cource there are some DB abstraction layers, like MDB2 from
Pear, but they all just wrap around the standard php library, as far as
I am concerned. Sqlite dll is probably not an option because on the
production system the DB will run under Linux.
Thanks a lot!
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
