# Can't install sqlite3 on Windows XP: Please Help! **URL:** \ **Category:** Ruby\ **Created:** [March 2, 2010, 12:14am UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404 "2010-03-02T00:14:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 12:14am UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/1 "2010-03-02T00:14:11Z")
I am trying to install ruby on windows with gem sqlite3 version 1.2.3 I have followed all the instructions here: [http://wiki.devchix.com/index.php?title=Server\_2003](http://wiki.devchix.com/index.php?title=Server_2003) and get stuck on the sqlite install: here is the error I get. Please help! I’ve looked everywhere for a solution, but can’t resolve it. C:\Ruby\lib\ruby\gems\1.8\cache\> 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 C:\Ruby\lib\ruby\gems\1.8\cache\> 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 \*\*\* extconf.rb failed \*\*\* Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: –with-opt-dir –without-opt-dir –with-opt-include –without-opt-include=${opt-dir}/include –with-opt-lib –without-opt-lib=${opt-dir}/lib –with-make-prog –srcdir=. –curdir –ruby=C:/Ruby/bin/ruby –with-sqlite3-dir –without-sqlite3-dir –with-sqlite3-include –without-sqlite3-include=${sqlite3-dir}/include –with-sqlite3-lib –without-sqlite3-lib=${sqlite3-dir}/lib –with-rtlib –without-rtlib my environment information: C:\Ruby\lib\ruby\gems\1.8\cache\>gem env RubyGems Environment: - RUBYGEMS VERSION: 1.3.6 - RUBY VERSION: 1.8.6 (2008-08-11 patchlevel 287) [i386-mswin32] - INSTALLATION DIRECTORY: C:/Ruby/lib/ruby/gems/1.8 - RUBY EXECUTABLE: C:/Ruby/bin/ruby.exe - EXECUTABLE DIRECTORY: C:/Ruby/bin - RUBYGEMS PLATFORMS: - ruby - x86-mswin32-60 - GEM PATHS: - C:/Ruby/lib/ruby/gems/1.8 - C:/Documents and Settings/jvajda/.gem/ruby/1.8 - GEM CONFIGURATION: - :update\_sources =\> true - :verbose =\> true - :benchmark =\> false - :backtrace =\> false - :bulk\_threshold =\> 1000 - REMOTE SOURCES: - [http://rubygems.org/](http://rubygems.org/) ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 12:39am UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/2 "2010-03-02T00:39:52Z")
John V. wrote: > I am trying to install ruby on windows with gem sqlite3 version 1.2.3 I > have followed all the instructions here: > [http://wiki.devchix.com/index.php?title=Server\_2003](http://wiki.devchix.com/index.php?title=Server_2003) and get stuck on the > sqlite install: here is the error I get. Please help! I’ve looked > everywhere for a solution, but can’t resolve it. > > (…) Try “gem install amalgalite”. hth, Siep ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 2:36am UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/3 "2010-03-02T02:36:41Z")
Further updated instructions here: [http://intertwingly.net/blog/2010/02/25/Ruby-Installer-on-Windows](http://intertwingly.net/blog/2010/02/25/Ruby-Installer-on-Windows) ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 10:46am UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/4 "2010-03-02T10:46:01Z")
On Mar 2, 12:14 am, John V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > I am trying to install ruby on windows with gem sqlite3 version 1.2.3 I > have followed all the instructions here:[http://wiki.devchix.com/index.php?title=Server\_2003and](http://wiki.devchix.com/index.php?title=Server_2003and) get stuck on the > sqlite install: here is the error I get. Please help! I’ve looked > everywhere for a solution, but can’t resolve it. Sure you looked everywhere? [http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-sqlite3/](http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-sqlite3/) The DevChix wiki recommend some changes that I would personally not apply. > C:\Ruby\lib\ruby\gems\1.8\cache\> 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 As far as the gem installation error you’re receiving, is weird: - There is a native gem for “i386-mswin32” platform (your ruby installation) in RubyGems: [sqlite3-ruby | RubyGems.org | your community gem host](http://rubygems.org/gems/sqlite3-ruby/versions/1.2.5-x86-mswin32) Which could be, since you’re installing from inside the cache folder, taking an old version of sqlite3-ruby gem. Can you try installation OUTSIDE that folder? or remove any sqlite3- ruby gem that is there. Somehow in your stripping of info removed the path to the “.out” file which could have helped to determine the version you’re trying to install. > ``` > - ruby > > ``` > > - REMOTE SOURCES: > -[http://rubygems.org/](http://rubygems.org/) I would recommend upgrading to RC2 of RubyInstaller, and moving forward, move to 1.8.7 as it became the stable and supoorted version of 1.8 line, while 1.8.6 remains only for legacy support. ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 9:05pm UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/5 "2010-03-02T21:05:43Z")
Siep K. wrote: > John V. wrote: > > > I am trying to install ruby on windows with gem sqlite3 version 1.2.3 I > > have followed all the instructions here: > > [http://wiki.devchix.com/index.php?title=Server\_2003](http://wiki.devchix.com/index.php?title=Server_2003) and get stuck on the > > sqlite install: here is the error I get. Please help! I’ve looked > > everywhere for a solution, but can’t resolve it. > > > > (…) > > Try “gem install amalgalite”. > > hth, > > Siep ok Thanks! I did this, and installed a few other gems which ruby called for. Now I get this error: nmake ‘nmake’ is not recognized as an internal or external command, operable program or batch file. any ideas? ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 9:06pm UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/6 "2010-03-02T21:06:57Z")
> I would recommend upgrading to RC2 of RubyInstaller, and moving > forward, move to 1.8.7 as it became the stable and supoorted version > of 1.8 line, while 1.8.6 remains only for legacy support. Anyway to simply upgrade my ruby env to 1.8.7 and not create all new ruby directories? Sorry I am new at this 🙂 ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 10:22pm UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/7 "2010-03-02T22:22:04Z")
On Mar 2, 9:09 pm, John V. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > ‘nmake’ is not recognized as an internal or external command, > operable program or batch file.any ideas? With which gem? Please provide enough information, even the whole output of your command will be very helpful. Also, please see my previous comment: install latest version of sqlite3-ruby. ---
**Author:** ![vaughajj](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/0ea827/32.png) [@vaughajj](https://www.ruby-forum.com/u/vaughajj)\ **Post date:** [March 2, 2010, 9:08pm UTC](https://www.ruby-forum.com/t/cant-install-sqlite3-on-windows-xp-please-help/184404/8 "2010-03-02T21:08:56Z")
> > Try “gem install amalgalite”. > > > > hth, > > > > Siep ok Thanks! I did this, and got an error when installing amagalite; Now I get this error: > nmake ‘nmake’ is not recognized as an internal or external command, operable program or batch file.any ideas?