On my mac, sqlite3 -version shows 3.1.3 which is not forward compatible with the default format for 3.3.6 unless you use the PRAGMA:
PRAGMA legacy_file_format=TRUE; Before you create the database. To use the old version as the default, you can compile the lib yourself with: -DSQLITE_DEFAULT_FILE_FORMAT=1 Alternatively, you could get the source and build a compatible sqlite client. Pat -----Original Message----- From: Hartwig Wiesmann [mailto:[EMAIL PROTECTED] Sent: Sunday, July 09, 2006 3:25 PM To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3 on MacOSX Hello! I have created a database (let's name it "Test.db") on the Mac by using the sqlite lib (sqlite version 3.3.6) in my program. Everything works fine. I also wanted to check the database contents using the sqlite command line program. Calling "sqlite3 Test.db" from the terminal and afterwards sending the command ".databases" leads to an error message "unsupported file format". What am I doing wrong? Hartwig
