Installing sqlite3 gem on Windows

Rails
1

Hi,

I’m new to Rails (and fairly new to Ruby) and am attempting to follow
the tutorial at
http://guides.rubyonrails.org/getting_started_with_rails.html

In that guide I’m stuck at 4.1 - I can launch the server fine and the
‘welcome aboard’ page appears as normal; however when I go to home/index
I get an error page like the following:

MissingSourceFile in HomeController#index
no such file to load – sqlite3
This error occurred while loading the following files:
sqlite3

I’ve attempted to install the sqlite3-ruby gem but get this error:

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

D:/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
D:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4 for inspection.
Results logged to
D:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3_api/gem_make.out

When I run ‘gem list’ sqlite3 comes up but I still receive this error.
My version information is as follows:

D:.…\blog>ruby -v
ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32]
(installed via one-click installer w/scite, fxri etc.)

D:.…\blog>rails -v
Rails 2.2.2
(installed via gem)

I’m really interested in learning to use Rails and am grateful for any
feedback and support.

Thanks,
Ross

2

Version 1.2.4 of sqlite3-ruby require build environment to be
installed and set, and I think it requires old version of Visual
Studio (6.0). If you want to install sqlite3-ruby gem try with:

gem install sqlite3-ruby -v 1.2.3

This will install version 1.2.3 which already has Win32 binaries. In
addition you must set your PATH environment variable to include folder
where you save sqlite3.dll.

On Jan 25, 11:00 pm, Ross M. [email protected]

3

You need to install sqlite3 before you can install sqlite3-ruby. See:
http://www.sqlite.org/ for download and install instructions.

On Jan 25, 12:00 pm, Ross M. [email protected]

4

Bosko I. wrote:

Version 1.2.4 of sqlite3-ruby require build environment to be
installed and set, and I think it requires old version of Visual
Studio (6.0). If you want to install sqlite3-ruby gem try with:

gem install sqlite3-ruby -v 1.2.3

This will install version 1.2.3 which already has Win32 binaries. In
addition you must set your PATH environment variable to include folder
where you save sqlite3.dll.

Unfortunately there is not a version 1.2.4 of the sqlite3-ruby gem that
works on Windows. I’ve got 3 different version of MS Visual Studio
(2003, 2005 and 2008) and none of them can compile the gem correctly,
setting the environment vars for each version gives different errors.
I’ve posted about this problem a few times, and I believe the maintainer
of the gem has no plans to support any version of the gem > 1.2.3

http://weblog.jamisbuck.org/2008/12/7/sqlite3-ruby-windows-builds