Install Issue with sqlite3.dll

Hi, I’m trying to install RoR on my computer following the instructions on the download page (http://rubyonrails.org/download). I’ve followed the instructions to the letter, trying I think 4 or 5 times (each time a fresh install), and each time when I get to the “rails server” step I get a missing sqlite3.dll error.

I am confident I have installed everything correctly (having configured Apache recently I am not new to this). I tried with the default Ruby location on C:\ drive and once with Ruby placed in my localhost folder (which is different from C:). Regardless I get the same issue.

After I try “rails server” line the first time it asks me to do a “bundle install” which I do, and then the next time I try “rails server” I get the sqlite3.dll error.

Any help would be greatly appreciated.

  • Parth

You need to put sqlite3.dll in the ruby bin dir or you can try http://rubyinstaller.org/

Hi
It seems you r on windows system

You must put sqlite3.dll file into directory c:\windows\system32

see this
http://www.ruby-forum.com/topic/149431

Thanks and regards,
Shyam Mohan

Ruby on rails developer
Mobile : +91(0)86-8846-8400

Web : shyam.heroku.com

I tried following the install instructions and manually putting sqlite3.dll into the appropriate gems subdirectory. This did not help. Further, I do not feel comfortable adding any files to the Windows/System32 folder. If this needed to happen, the installer would have done so, no?
Again to trace my exact steps to help troubleshooting:

  1. Ran installer for 1.9.2. Installed in C:\Ruby192
  2. Extracted RubyGems into C:\rubygems-1.5.0. Ran the “setup.rb” file.
  3. Performed “**gem install rails”**4) Created an app folder per download instructions as follows: “**rails new C:\testApp”**5) In Ruby Cmd, "cd path/to/your/new/application"
  4. In Ruby Cmd, "rails server"

Error: no sqlite3.dll found, error within cmd

  1. In Ruby cmd, “bundle install” per suggestion.
  2. In Ruby cmd, tried “rails server” again, only to get a pop-up this time saying sqlite3.dll not found.

Not really sure where I went wrong…doesn’t make sense to use an installer if it doesn’t include the right files in the proper locations.

Thanks for your help so far, looking for something more directed rather than what I’ve already seen on google and couldn’t get that to work…

Sorry in Step 5, it was “cd C:\testApp” as that is appropriate.

Whatever directory you use to put your sqlite3.dll it must be in your
path. If you want to put it in your system directories (which I do not
recommend) like Windows\System32 they are already in the path. If you
install Ruby with RubyInstaller's installer and selected to put it to
the path you can copy sqlite3.dll into bin directory of your Ruby
installation. Finally if you want to keep things clean you can always
create separate directory, save sqlite3.dll there then go to Control
Panel->System->Advanced System Settings->Environment variables... and
add new directory to the path.

Regards,
Boško Ivanišević

Thank you greatly for your help Bosko. After another try and some help from a friend of mine your suggestions seem to have fixed the issue. Much appreciated!

Parth and Bosko, I'm having the same problem on Vista. So I went
looking for an sqlite3.dll, found one somewhere and put it into
Ruby192\bin but must have found an incompatible one because when I run
rails server I get a message that says "no entry point for
sqlite3_something_something". Where did you get your working
sqlite3.dll? (I'm feeling pretty dumb right now!)

  Dennis
408-202-2385

Parth B wrote in post #979689:

Ah, found it thanks to Alan Skorkin's blog, "Skorks". It's working.
Thanks all for your various previous informative posts.

  Dennis

Dennis R. wrote in post #980981:

Parth B wrote:

After I try "rails server" line the first time it asks me to do a "bundle
install" which I do, and then the next time I try "rails server" I get the
sqlite3.dll error.

Any help would be greatly appreciated.

http://www.fix-all-dll-errors.com/sqlite3.dll/

You can fix it from the link given above. It will solve the problem.

Parth B wrote:

> After I try "rails server" line the first time it asks me to do a "bundle
> install" which I do, and then the next time I try "rails server" I get the
> sqlite3.dll error.

> Any help would be greatly appreciated.

http://www.fix-all-dll-errors.com/sqlite3.dll/

You can fix it from the link given above. It will solve the problem.

Actually, more accurate is the post install message the gem
installation gives you: