From: Luis Lavena <luislavena@...>
Date: 2009-06-05T09:15:05+09:00
Subject: Re: Can't install sqlite3-ruby gem in Windows

On Jun 4, 1:32 pm, Nova Pon <nova....@gmail.com> wrote:
> I'm also having problems installing the sqlite3 gem on Windows.  I
> downloaded  sqlite-3_6_14_2.zip and sqlitedll-3_6_14_2.zip fromhttp://www.sqlite.org/download.htmland extracted them to
> /WINDOWS/SYSTEM 32.  But when I type gem install sqlite3-ruby in the
> command line I get:
> Building native extensions.  This could take a while...
> ERROR:  Error installing sqlite3-ruby:
>         ERROR: Failed to build gem native extension.
>
> c:/ruby/bin/ruby.exe extconf.rb
> 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:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1
> 2.4 for inspection.
> Results logged to
> c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3_
> api/gem_make.out
>
> C:\Documents and Settings\Nova>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:/ruby/bin/ruby.exe extconf.rb
> 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:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1
> 2.4 for inspection.
> Results logged to
> c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3_
> api/gem_make.out
>
> C:\Documents and Settings\Nova>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:/ruby/bin/ruby.exe extconf.rb
> 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:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1
> 2.4 for inspection.
> Results logged to
> c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3_
> api/gem_make.out
>
> Please help!! Thanks

This has been covered before on this list, but just for the record:

Latest version of sqlite3-ruby lacks binaries for Windows. For you to
build using version 1.2.4 of the gem also requires a compiler, which
in your case must be Microsoft Visual C 6.0

Since is an obsolete compiler, highly unlikely you will find a
downloadable version.

Please force the installation to prior version:

gem install sqlite3-ruby -v=1.2.3

HTH,
--
Luis Lavena