# Unsupported file format (SQLite3)

**URL:** <https://www.ruby-forum.com/t/unsupported-file-format-sqlite3/57637>\
**Category:** Ruby\
**Created:** [April 12, 2006, 6:14pm UTC](https://www.ruby-forum.com/t/unsupported-file-format-sqlite3/57637 "2006-04-12T18:14:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ian](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/bb73d2/32.png) [@ian](https://www.ruby-forum.com/u/ian)\
**Post date:** [April 12, 2006, 6:14pm UTC](https://www.ruby-forum.com/t/unsupported-file-format-sqlite3/57637/1 "2006-04-12T18:14:24Z")

</div>

I’m running sqlite3-ruby 1.1.0 and sqlite 3.3.4 on 2 linux machines. I  
create a (small, single table) database on 1 machine, and I can re-open  
it and work with it fine on that machine.

I copy it over to the other and can do:  
zdb = SQLite3::Database.new( zf )  
but then it crashes on the next line:  
z = zdb.execute(“select \* from Data”)  
with:

/usr/local/lib/ruby/site\_ruby/1.8/sqlite3/errors.rb:94:in `check': unsupported file format (SQLite3::SQLException) from /usr/local/lib/ruby/site_ruby/1.8/sqlite3/statement.rb:70:in`initialize’  
from /usr/local/lib/ruby/site\_ruby/1.8/sqlite3/database.rb:183:in  
`prepare' from /usr/local/lib/ruby/site_ruby/1.8/sqlite3/database.rb:210:in`execute’  
from f.rb:9

The sqlite3 cl tool handles it fine, so does Mono.

Any help much appreciated.