Sunday, May 1, 2011

Ruby on Rails missing sqlite3.dll

I was following the official guide at on how to set up Ruby on Rails. At step 3.4 Configuring a Database I got the following error message:
"The program can't start because sqlite3.dll is missing from your computer. Try reinstalling the program to fix this problem."

After quite a lot of googling I found that the problem was that the sqlite3 gem
(installed with the bundle install in step 3.3 I believe) didn't include windows DLL. This is probably because "most Ruby developers use Linux".

The solution is to download the DLL from the official SQLite website You want the "This ZIP archive contains a DLL for the SQLite library" file. At the time of writing it is the following file:
Put the files from the ZIP file into your ruby/bin directory. Close and open a new console window and continue with the Ruby on Rails guide.

1 comment: