From: Jamis Buck <jamis@37signals.com>
Date: 2006-02-02T07:22:12+09:00
Subject: Re: Sqlite3 error on Mac OS X

On Feb 1, 2006, at 2:38 PM, Dan Munk wrote:

> Hi,
>
> I am having problems with sqlite connectivy.  When I use the require
> command with 'SQLite3' everything works fine.  The problem is that
> active record uses 'sqlite'.  I was hoping to get some advice on the
> best way to get everything in sync.

Note that 'sqlite' and 'sqlite3' are distinct. require 'sqlite' tries  
to bring in the Sqlite 2.x bindings. Try doing "gem install sqlite- 
ruby" and then just do "require 'sqlite'" and you should be good.

That, or configure AR to use sqlite3 instead of sqlite:

   adapter: sqlite3

- Jamis

>
> irb(main):001:0> require 'rubygems'
> => true
> irb(main):002:0> require 'SQLite3'
> => true
> irb(main):003:0> require 'sqlite'
> LoadError: no such file to load -- sqlite
>         from
> /opt/local/lib/ruby/vendor_ruby/1.8/rubygems/custom_require.rb:21:in
> `require__'
>         from
> /opt/local/lib/ruby/vendor_ruby/1.8/rubygems/custom_require.rb:21:in
> `require'
>         from (irb):3
> irb(main):004:0>
>
> Thanks,
> Dan
>
>