# Sqlite3 error on Mac OS X

**URL:** <https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939>\
**Category:** Ruby\
**Created:** [February 1, 2006, 10:48pm UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939 "2006-02-01T22:48:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e5b9ba/32.png) [@dkam](https://www.ruby-forum.com/u/dkam)\
**Post date:** [February 1, 2006, 10:48pm UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939/1 "2006-02-01T22:48:31Z")

</div>

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.

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

---

<div class="post-metadata">

**Author:** ![dkam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e5b9ba/32.png) [@dkam](https://www.ruby-forum.com/u/dkam)\
**Post date:** [February 1, 2006, 11:03pm UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939/2 "2006-02-01T23:03:44Z")

</div>

Is the problem in your database.yml file?

development:  
adapter: sqlite3  
dbfile: db/dev.db

---

<div class="post-metadata">

**Author:** ![dkam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e5b9ba/32.png) [@dkam](https://www.ruby-forum.com/u/dkam)\
**Post date:** [February 1, 2006, 11:49pm UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939/3 "2006-02-01T23:49:37Z")

</div>

That was my problem, thanks for your help.

---

<div class="post-metadata">

**Author:** ![dkam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e5b9ba/32.png) [@dkam](https://www.ruby-forum.com/u/dkam)\
**Post date:** [February 2, 2006, 1:09am UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939/4 "2006-02-02T01:09:17Z")

</div>

On Feb 1, 2006, at 2:38 PM, Dan M. 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

---

<div class="post-metadata">

**Author:** ![dkam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/e5b9ba/32.png) [@dkam](https://www.ruby-forum.com/u/dkam)\
**Post date:** [February 2, 2006, 1:18am UTC](https://www.ruby-forum.com/t/sqlite3-error-on-mac-os-x/99939/5 "2006-02-02T01:18:25Z")

</div>

Did you install it using rubygems?  
Had a similar problem after installing it with a gem, couldnt get it  
working. In the end i  
downloaded the source and compiled it myself, worked fine after that.  
seems to be some  
sort of gem issue on os x or some such.

- Marius