Ruby Forum Ruby on Rails > Installing SQLite3 on windows

I need to do some lightweight code testing so I decided to install
sqlite3 in my laptop (MS-WinXPproSP2) rather than have to create
PostgreSQl DBs. I installed the three required files (sqlite3.def,
sqlite3.exe, and sqlite3.dll) into the same directory as the ruby.exe,
which is on the path.  I also installed the sqlite-ruby gem.

In my project root, when I type rake db:create I get this error thrown:

invert> rake db:create --trace
(in C:/Documents and Settings/byrnejb/My Documents/My
Projects/ca.harte-lyne.s
tem/invert)
** Invoke db:create (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:create
rake aborted!
no such file to load -- sqlite3
c:/usr/lib/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`gem_o
ginal_require'
c:/usr/lib/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`requi
'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
pendencies.rb:496:in `require'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
pendencies.rb:342:in `new_constants_in'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
pendencies.rb:496:in `require'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
re_ext/kernel/requires.rb:7:in `require_library_or_gem'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
re_ext/kernel/reporting.rb:11:in `silence_warnings'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.2/lib/active_support/
re_ext/kernel/requires.rb:5:in `require_library_or_gem'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/co
ection_adapters/sqlite3_adapter.rb:10:in `sqlite3_connection'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/co
ection_adapters/abstract/connection_specification.rb:291:in `send'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/co
ection_adapters/abstract/connection_specification.rb:291:in
`connection='
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/co
ection_adapters/abstract/connection_specification.rb:259:in
`retrieve_connecti
'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/co
ection_adapters/abstract/connection_specification.rb:78:in `connection'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:36
n `create_database'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rails-2.0.2/lib/tasks/databases.rake:30
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`call'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in
`execute'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`each'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in
`execute'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in
`invoke_w
h_call_chain'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
`synchron
e'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in
`invoke_w
h_call_chain'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in
`invoke'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in
`invoke_
sk'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_lev
'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`each'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in
`top_lev
'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
`standar
exception_handling'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in
`top_lev
'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in
`run'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in
`standar
exception_handling'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in
`run'
c:/usr/lib/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31
c:/usr/lib/ruby/bin/rake:19:in `load'
c:/usr/lib/ruby/bin/rake:19

invert>
invert> dir \usr\lib\ruby\bin\sql*
 Volume in drive C has no label.
 Volume Serial Number is 6DC8-12AF

 Directory of C:\usr\lib\ruby\bin

2008 Feb 06  10:04             3,153 sqlite3.def
2008 Feb 06  10:04           431,163 sqlite3.dll
2008 Feb 06  10:04           439,292 sqlite3.exe
2007 Dec 14  10:48            11,200 sqlsh.rb
               4 File(s)        884,808 bytes
               0 Dir(s)  74,278,727,680 bytes free

invert>

What am I missing?

James Byrne wrote:
> 
> What am I missing?

gem uninstall sqlite-ruby
...
gem install sqlite3-ruby
...

da-ta!

James Byrne wrote:

> gem uninstall sqlite-ruby
> ...
> gem install sqlite3-ruby

Thank you!  That was very helpful.