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

Posted by Rock Hudson
Rock Hudson
27,595 Points

SQLite3 Error when installing for Windows 64bit... Please help :(

Alright folks... It is now 3am and I have been trying to get SQLite3 to install with no success :(

I am currently using a Windows 7 64bit system... everything else installed fine, just not SQLite3.

error says:

checking for sqlite3.h... no sqlite3.h is missing.

I tried to install SQLite3 with no success...

If you have solved this problem, any/all help would be greatly appreciated as I need to learn RoR asap :)

Jason Goebel
Jason Goebel
4,351 Points
Jason Goebel
Jason Goebel
4,351 Points

Rick Dawson , this was tricky and it took me about 15 min to figure it out. Here is what i did:

1: Go to: www.sqlite.org/download.html

2: Download <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-shell-win32-x86-3080701.zip </a> and the <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-dll-win32-x86-3080701.zip </a> files under Precompiled Binaries for Windows. (versions may differ)

3: Extract both the files into the Ruby[ver]/bin directory. Ex. c:\Ruby21-x64\bin\

4: Now try again: gem install sqlite3

That should work. That is how I fixed the stipulation.

OS: Windows 8.1