Sqlite3 installation on windows 8

Folks,

I just used rails installer to install ruby on rails on my windows 8 machine. I was happy to see that my installation went through without any issue. As most of you know, it creates a dummy rails app on installation, todo app. I thought of running this before jumping into something else.

So, I did "bundle install" and then "rails s" to run server, it went well until I typed "localhost:3000" in my browser. Message I got in console was :

ERROR LoadError: Please install the sqlite3 adapter: 'gem install ativerecord-dqlite-adapter'

I needed to update the certificates(.pem file) to install sqlite3(Thanks to ruby-forum for helping me on this as well). Now, I can see that even sqlite3 is also installed on my machine.

Doing "bundle show sqlite3" gives : C:/Rails Installer/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sqlite3-1.3.8-x86-mingw32

Fair enough. So, I should be able to run server now. Right?

Surprisingly, "rails s" is giving me another error message now. Message is : C:/Rails Installer/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sqlite3-1.3.8-x86-mingw32/lib/sqlite3.rb: in 'require' : cannot load such file -- sqlite3/sqlite3_native from ... ....

Happily, I resolved this problem with the help of "cannot load such file -- sqlite3/sqlite3_native (LoadError) on ruby on rails" But I seem to have caught in another problem after that. Problem is:

ERROR LoadError : Please install the sqlite3 adapter: gem install activerecord-sqlite3-adapter

Doing "gem install activerecord-sqlite3-adapter" gives

ERROR: Could not find a valid gem 'activerecord-sqlite3-adapter'.

Any idea? I wonder which adapter is it talking about..