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***http://rubyforge.org/frs/shownotes.php?release_id=45314
*). 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

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ć

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:

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!

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!

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 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:

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 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.

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

View this message in context:
http://old.nabble.com/Install-Issue-with-sqlite3.dll-tp30826621p31706143.html
Sent from the RubyOnRails Users mailing list archive at Nabble.com.

On May 26, 7:33am, timmickelson [email protected] wrote:

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:

gem install sqlite3

=============================================================================

You’ve installed the binary version of sqlite3.
It was built using SQLite3 version 3.7.3.
It’s recommended to use the exact same version to avoid potential
issues.

At the time of building this gem, the necessary DLL files where
available
in the following download:

http://www.sqlite.org/sqlitedll-3_7_3.zip

You can put the sqlite3.dll available in this package in your Ruby
bin
directory, for example C:\Ruby\bin

=============================================================================

Successfully installed sqlite3-1.3.3-x86-mingw32
1 gem installed

There you have the right instructions.

Download that binary from sqlite.org and place it somewhere in the
PATH, could be Ruby own ‘bin’ directory.

The problem is that bundle chews that message so users don’t see what
are the manual steps involved.

HTH,

Luis L.