# Unable to install sqlite3

**URL:** <https://www.ruby-forum.com/t/unable-to-install-sqlite3/152368>\
**Category:** Rails\
**Created:** [November 3, 2008, 6:56am UTC](https://www.ruby-forum.com/t/unable-to-install-sqlite3/152368 "2008-11-03T06:56:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![up1notch](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/47e85d/32.png) [@up1notch](https://www.ruby-forum.com/u/up1notch)\
**Post date:** [November 3, 2008, 6:56am UTC](https://www.ruby-forum.com/t/unable-to-install-sqlite3/152368/1 "2008-11-03T06:56:26Z")

</div>

I am new to Ruby. Try out a web application, but when I tried to access  
the page, it has the following error (see ERROR 1 below).

So I thought I may have not installed “sqlite3” and tried downloading  
“sqlite\_3-6-4.zip” and “sqlitedll\_3-6-4.zip”, unzipped it and place it  
in ruby’s bin directory. Then I run the command:

gem install sqlite3-ruby

But found myself encounter the another error shown below (see ERROR 2).

Any help would by wonderful

# ============================== ERROR 1

MissingSourceFile (no such file to load – sqlite3):  
C:/Programs2/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`g em_original_require' C:/Programs2/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in`r  
equire’  
…  
…  
C:/Programs2/Ruby/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`r  
equire’  
script/server:3

# Rendering C:/Programs2/Ruby/lib/ruby/gems/1.8/gems/actionpack-2.0.2/lib/action\_c ontroller/templates/rescues/layout.erb (internal\_server\_error) ============================== ERROR 1

# ============================== ERROR 2

C:/Programs2/Ruby\>gem install sqlite3-ruby  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.

C:/Programs2/Ruby/bin/ruby.exe extconf.rb install sqlite3-ruby  
checking for fdatasync() in rt.lib… no  
checking for sqlite3.h… no

nmake  
‘nmake’ is not recognized as an internal or external command,  
operable program or batch file.

# Gem files will remain installed in C:/Programs2/Ruby/lib/ruby/gems/1.8/gems/sqli te3-ruby-1.2.4 for inspection. Results logged to C:/Programs2/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ex t/sqlite3\_api/gem\_make.out ============================== ERROR 2

---

<div class="post-metadata">

**Author:** ![up1notch](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/47e85d/32.png) [@up1notch](https://www.ruby-forum.com/u/up1notch)\
**Post date:** [November 3, 2008, 7:05am UTC](https://www.ruby-forum.com/t/unable-to-install-sqlite3/152368/2 "2008-11-03T07:05:58Z")

</div>

This is a known problem. Hope the link below helps:  
[http://domhackers.blogspot.com/2008/09/sqlite3-ruby-gem-on-windows.html](http://domhackers.blogspot.com/2008/09/sqlite3-ruby-gem-on-windows.html)

Cheers,  
Mohit.  
11/3/2008 | 2:04 PM.

---

<div class="post-metadata">

**Author:** ![up1notch](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/47e85d/32.png) [@up1notch](https://www.ruby-forum.com/u/up1notch)\
**Post date:** [November 3, 2008, 5:20pm UTC](https://www.ruby-forum.com/t/unable-to-install-sqlite3/152368/3 "2008-11-03T17:20:52Z")

</div>

Thanks! It works!

Mohit S. wrote:

> This is a known problem. Hope the link below helps:  
> [http://domhackers.blogspot.com/2008/09/sqlite3-ruby-gem-on-windows.html](http://domhackers.blogspot.com/2008/09/sqlite3-ruby-gem-on-windows.html)
> 
> Cheers,  
> Mohit.  
> 11/3/2008 | 2:04 PM.