Can't install sqlite3-ruby gem in Windows

[Nova Pon]

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 from
http://www.sqlite.org/download.html and 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

 

[Luis Lavena]

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,

 

[John T.]

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

This is not quite true. I have several versions of Visual Studio on this
system - VC 6, Visual Studio 2003, 2005 and 2008, and none of these can
compile the gem, they all kick out various errors.

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

This is the only solution. Especially since the (ex)maintainer of gem is
not supporting it anymore.

 

[Nova Pon]

Thanks so much! That worked

 

[Luis Lavena]

This is not quite true. I have several versions of Visual Studio on this
system - VC 6, Visual Studio 2003, 2005 and 2008, and none of these can
compile the gem, they all kick out various errors.

Because you also need to correct the extconf.rb in the source file and
patch rbconfig of your ruby to support your compiler.

Plus you need headers and libs of sqlite3 to successfuly built it.

Been there, done that.

This is the only solution. Especially since the (ex)maintainer of gem is
not supporting it anymore.

That's why I've been working on a 1.8 and 1.9 version of the gem,
forked from original (ex)maintainer:

http://github.com/luislavena/sqlite3-ruby/tree/master

Still tests are failing on 1.9, one of the reasons I'm not sending a
pull request to James Buck to merge and integrate those.

Also, working on fat binaries for 1.9 and 1.8 to workaround issues
when installing the exact same gem binary on differnt ruby versions.

Busy busy busy

Regards,

 

[Roger Pack]

This is not quite true. I have several versions of Visual Studio on this

system - VC 6, Visual Studio 2003, 2005 and 2008, and none of these can
compile the gem, they all kick out various errors.

Luis' fork does build with mingw.
http://programming-gone-awry.blogspot.com/2009/05/how-to-install-sqlite3-binaries-on-ruby.html
might help.
Cheers!
-=r