RoR working on Windows 7 without Instant Rails

Lots of people have been getting sqlite3 errors with this so I thought
I would post how I got it working.

1. Install Ruby. (Go to http://rubyonrails.org/download and run the
Windows installer. At the time of writing, I ran rubyinstaller-1.9.2-
p0.exe.)

2. Install Ruby Gems. (At the time of writing I installed
rubygems-1.3.7.zip and then extracted the files and ran 'ruby
setup.rb' from the command line.)

3. Install Rails. ('gem install rails' from the command line.)

4. You need to make sure sqlite3.dll, mozcrt19.dll, and sqlite3.def
are in your ruby\bin directory and sqlite3 is in your gemfile. Also,
NONE of these are included in the libraries even if you try 'gem
install sqlite3' so you have to manually scavenge the web for them.

Once I did all this and restarted my console it worked!

1. Install Ruby...
2. Install Ruby Gems...
3. Install Rails...
4. You need to make sure sqlite3.dll, mozcrt19.dll, and sqlite3.def
are in your ruby\bin directory and sqlite3 is in your gemfile.

I did this

1.
http://rubyforge.org/frs/download.php/72170/rubyinstaller-1.9.2-p0.exe
2. (nothing - gem command is included in installation)
3. gem install rails
4. gem install sqlite3-ruby

That printed a message to get sqlite from:

  http://www.sqlite.org/sqlitedll-3_6_23_1.zip

and copy it to ruby/bin. Which I did, and rails worked.
BTW - mozcrt19.dll is not required.

5. Do yourself a favor and install Devkit from

  http://github.com/downloads/oneclick/rubyinstaller/DevKit-4.5.0-20100819-1536-sfx.exe

This adds support for building native C gems (RedCloth, nokogiri,
EventMachine...) just as linux/macosx/unix do - via the same gem install
command.