Rails Question: Sqlite3 dll not found on windows (even the old 1.2.3 version)

Question

I followed the suggestion here: and the gem seemed to install correctly, but when I ran rake:db:migrate from the windows command line, I got a full on pop up saying:

"This application has failed to start because sqlite3.dll was not found. Re-installing the application may fix this problem"

which is really weird, because normally (when I have no sqlite3), I get a text error in line with the other debug statements on the command line.

I'm installing sqlite3-ruby -v 1.2.3 (but it does the same thing with ANY version of sqlite3 I try to install, now...even the newest one (1.2.5, which has a bunch of "No definition" errors when I try to install it))

Answer 1

Silly question but: you have installed the sqlite gem but have you installed the sqlite application yet?

The gem is just the way your rails program will talk to the real sqlite application. If you don't have that installed, then there's nothing for it to talk to. I'm guessing that installing sqlite application will install the sqlite3.dll and then it'll all work again.