Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Installing a Ruby Development Environment Installing a Ruby Development Environment Installing Ruby on Windows

Are there any tutorials on installing sqlite3? I've wasted a week and still can't execute: bundle exec rails server.

I've researched and created Paths, moved files into folders, and everything else stackoverflow suggests. I have these files in my C:\Ruby22\bin folder.
sqlite-analyzer-win32-x86-3080803 sqlite-dll-win32-x86-3080803 sqlite-shell-win32-x86-3080803

This folder is also in my Paths as: C:\Ruby22\bin when I execute: echo %PATH%. When I try to get to the server with: bundle exec rails server I get a message stating:

C:/Ruby22/lib/ruby/gems/2.2.0/gems/sqlite3-1.3.10-x86-mingw32/lib/sqlite3.rb:6:in 'require': cannot load such file --swlite3/sqlite3_native (LoadError).

Any help will be appreciated. Thanks.

As for my question above, I am working on Windows 8.1. Thanks

Anthony Lucio
Anthony Lucio
20,431 Points

Start over and install Ruby 2.0. Not Ruby 2.2.

7 Answers

I've not done the install on a Windows box, but below are some resources I've found. http://dev.mysql.com/doc/refman/5.7/en/windows-installation.html https://www.youtube.com/watch?v=N3Xc1uLhXoU

I found this helpful, but for a similar problem when installing MySQL on OSX: http://stackoverflow.com/questions/17643897/cannot-load-such-file-sqlite3-sqlite3-native-loaderror-on-ruby-on-rails

Merritt Lawrenson
Merritt Lawrenson
13,477 Points

Also check out the video on the treehouse vm in vagrant. The vagrant vm will run run your code inside a virtual linux box. The great part is that it will share the files with the normal old windows file tree so you can still do the editing in windows with sublime or the text editor of your choice and then use the vm's command line to run commands like in the videos. It's easier than completely installing a separate operating system on your computer.

Jeff Jacobson-Swartfager
Jeff Jacobson-Swartfager
15,419 Points

In that case, check out the issues list (check out both the open and the closed issues). You may find something helpful.

I don't have access to a Windows machine at the moment, but a quick search through the issues list lead me to this issue and this thread.

Hopefully that helps, but since you're on Windows, I'd highly recommend partitioning your drive and installing a Linux distro for development. Unless you absolutely have to deploy to an IIS machine, you'll end up saving yourself a ton of headache if you develop Rails on Linux. Plus, it's free.

If you get things running on Windows, definitely post here/stackoverflow/your blog. You'll be in the minority by developing Rails on Windows, but you'll certainly be helping out the community significantly with your lessons learned.

Good luck!

Thank You, I will check these out today.

Jeff Jacobson-Swartfager
Jeff Jacobson-Swartfager
15,419 Points

Installing rails on Windows is a pain in the rear to do by hand. Luckily, the folks at Rails Installer have already done most of the hard work for you. Just download the exe and follow the instructions. Rails and its dependencies (like SQLite) will be installed for you!

That's what I've been working off of. I keep getting that error.

Thanks for the advice, I will look at these links and install Linux.