Getting started, sort of

I was working with:

The Rails Cookbook
A Ruby on Rails Crash Course
Brian Hogan

page 5

And I did this:

C:\ruby>gem install sqlite3-ruby

And I got this:

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 install sqlite3-ruby
checking for fdatasync() in rt.lib... no
checking for sqlite3.h... no

'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/
.2.4 for inspection.
Results logged to c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/


Any help or ideas would be appreciated

Roger Bird

Any help or ideas would be appreciated

Somewhere in here:

This was not all that helpful. I am sure that it is because I am
ignorant, but it was nevertheless not helpful. What do I do?
Uninstall my current version of gem and install the earlier version?

You did ask for "any help," right? Well that's weird, then, because
comments. Not good enough?

I've no experience with running Ruby or sqlite3 on windows, but it
looks like the program nmake isn't working right. I'll bet that's the
program used to build Ruby extensions for windows. Here's what I'd

do a search for the file nmake, and if you find it, make sure it's in
your path. The way I usually do this is just make a copy of it in
your windows folder or something. If you can't find it, it's gotta
come with some software package, or maybe you can just download the
executable from somewhere.

Hope this helps, and sorry if it doesn't! I totally understand not
being able to find something in google. Check this out, maybe it will


P.S. Ease up, guys, let's not start a flame war. No reason to spite.

I think you should install an earlier version of sqlite, I think that the new version of sqlite is not ready for windows, or install mysql instead of sqlite

I am sorry. I was told that this is a supportive blog. I guess I was
mistaken. I guess it is just another place for people to hone their
putdown skills.

When I click on that link I get 4,380 websites. Now, let me see.
Which one is the right on? When I click on the first site I seem to
get something but, it seems to ramble and does not really give very
good directions. Perhaps next time I should not ask for "any help"
but only "help for stupid people".

Roger Bird

I fixed the problem with Eric's original post. Like I said, I am
stupid. End of this discussion.

Hey, I wrote that :slight_smile:

Should have just sent me an email directly, I'd have helped you get it
working. I'll update the cookbook to reflect that issue. Thanks for
reminding me.