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. Similar files

[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.

[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-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 SQLite

[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

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 adapter. I've

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 adapter. I've

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

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

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

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, all sharing

[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

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