Re: [sqlite] "Unsupported File Format" from 3.1.3

2008-03-29 Thread D. Richard Hipp
On Mar 29, 2008, at 12:34 AM, Jerry Krinock wrote: > Someone sent me an sqlite database file. > > Opening in Mac OS 10.5 with the built-in sqlite 3.4.0, no problems. > > Opening in Mac OS 10.4 with the built-in sqlite 3.1.3, any query > returns sqlite error 1, "unsupported file format". > > Simila

[sqlite] "Unsupported File Format" from 3.1.3

2008-03-28 Thread Jerry Krinock
Someone sent me an sqlite database file. Opening in Mac OS 10.5 with the built-in sqlite 3.4.0, no problems. Opening in Mac OS 10.4 with the built-in sqlite 3.1.3, any query returns sqlite error 1, "unsupported file format". Similar files from other users open in either Mac OS/sqlite version.

Re: [sqlite] Unsupported file format

2007-05-11 Thread P Kishor
On 5/11/07, Alberto Simões <[EMAIL PROTECTED]> wrote: Hi, I am using a Mac, and probably doing something weird with fink software and (probably) other installations. The fact is that I create a database using DBD::SQLite, and then: [EMAIL PROTECTED] ProjectoDicionario]$ sqlite3 dic.db SQLit

[sqlite] Unsupported file format

2007-05-11 Thread Alberto Simões
Hi, I am using a Mac, and probably doing something weird with fink software and (probably) other installations. The fact is that I create a database using DBD::SQLite, and then: [EMAIL PROTECTED] ProjectoDicionario]$ sqlite3 dic.db SQLite version 3.2.8 Enter ".help" for instructions sqlite> .

Re: [sqlite] unsupported file format

2007-01-16 Thread Michael P. Soulier
On 1/16/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Every version of SQLite will read and write databases generated by all prior version of SQLite going back to 3.0.0. The reverse is That's odd then, since my db was made with 3.3.8, but a ruby gem made with 3.3.10 gave me this "unsupport

Re: [sqlite] unsupported file format

2007-01-16 Thread drh
"Michael P. Soulier" <[EMAIL PROTECTED]> wrote: > I checked with the maintainer, and he used the latest 3.3.10 sqlite. I > had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and > it's ok now. > > So, how would I work on, say, a couple of different windows boxes and > linux boxes, al

Re: [sqlite] unsupported file format

2007-01-16 Thread Bill KING
.dump? :) I think this is more a question for DRH tho. Michael P. Soulier wrote: > I checked with the maintainer, and he used the latest 3.3.10 sqlite. I > had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and > it's ok now. > > So, how would I work on, say, a couple of different wi

Re: [sqlite] unsupported file format

2007-01-16 Thread Michael P. Soulier
I checked with the maintainer, and he used the latest 3.3.10 sqlite. I had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and it's ok now. So, how would I work on, say, a couple of different windows boxes and linux boxes, all sharing the same sqlite3 database file, but with differen

Re: [sqlite] unsupported file format

2007-01-16 Thread Michael P. Soulier
On 1/16/07, Bill KING <[EMAIL PROTECTED]> wrote: Err, s/qt/ROR/ So, the sqlite3-ruby gem needs rebuilding then? I don't have a build environment for windows. I guess I'll point this out to the gem maintainer. Odd that I'm not running into this on any other windows system. My Linux boxes are fin

Re: [sqlite] unsupported file format

2007-01-16 Thread Bill KING
Michael P. Soulier wrote: > Hello, > > I just checked out my Rails project on windows, and I'm getting the error > > "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported > file format: > SELECT * FROM icps" > > It seems to be coming from sqlite3 itself, not from the ActiveRecord > ad

Re: [sqlite] unsupported file format

2007-01-16 Thread Bill KING
Michael P. Soulier wrote: > Hello, > > I just checked out my Rails project on windows, and I'm getting the error > > "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported > file format: > SELECT * FROM icps" > > It seems to be coming from sqlite3 itself, not from the ActiveRecord > ad

[sqlite] unsupported file format

2007-01-16 Thread Michael P. Soulier
Hello, I just checked out my Rails project on windows, and I'm getting the error "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported file format: SELECT * FROM icps" It seems to be coming from sqlite3 itself, not from the ActiveRecord adapter. I've searched and found many instan

[sqlite] "unsupported file format" when accessing sqlite3 DB with PDO in php

2006-10-10 Thread Inoqulath
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

Re: [sqlite] unsupported file format

2006-08-08 Thread Craig Morrison
Py Olivier wrote: Hello, After compiling I'm testing the C example program provided in the quick start page, just to get into the C/C++ interface for SQLite. ./exprog testdb 'select * from tbl1' The database file opens normaly, but I get an error coming from the sqlite3_exec method : SQL error

[sqlite] unsupported file format

2006-08-08 Thread Py Olivier
Hello, After compiling I'm testing the C example program provided in the quick start page, just to get into the C/C++ interface for SQLite. ./exprog testdb 'select * from tbl1' The database file opens normaly, but I get an error coming from the sqlite3_exec method : SQL error: unsupported file