On 24 Sep 2013, at 4:19am, Aryc <[email protected]> wrote: > I'm trying to use SQlite as a transfer medium between my PHP world and my > Python world. > in PHP i can read and write just fine. but when i try to read the database > from a python program i get the dreaded "file is encrypted or not a database" > message. > can any body help me?
The first thing to try is to make absolutely sure that they are both accessing the same file. If you are not specifying complete a path for the database file in both languages, please make that change, just for testing purposes. I think your PHP library is using a file format that is too new for your Python library. In both languages please execute the commands SELECT sqlite_version() PRAGMA journal_mode and tell us what you get back. You might also try the same thing in the opposite direction: delete the existing database file use Python to create the database file, a table in it, and a row in the table try to read the file from your PHP interface. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
