Forum: Ruby on Rails Installing sqlite3 gem on Windows

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
10ca0a44634dd52c7f4b34ad27ae5306?d=identicon&s=25 Ross Masters (rmasters)
on 2009-01-25 23:00
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...

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
Af2ce6689213fdb78913a9662b18da6b?d=identicon&s=25 Rick (Guest)
on 2009-01-26 06:00
(Received via mailing list)
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 Masters <rails-mailing-l...@andreas-s.net>
9770ee3431156709c728f6105dd98f0d?d=identicon&s=25 Bosko Ivanisevic (Guest)
on 2009-01-26 08:24
(Received via mailing list)
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 Masters <rails-mailing-l...@andreas-s.net>
32b703cdb0ea03c3939b97a93205414f?d=identicon&s=25 John T. (johnt519)
on 2009-01-26 15:16
Bosko Ivanisevic 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...
This topic is locked and can not be replied to.