Forum: Ruby on Rails Install Issue with sqlite3.dll

561f863a41eeda3bf34ff16ba8b2486c?d=identicon&s=25 Parth B (Guest)
on 2011-02-02 15:45
(Received via mailing list)
Hi, I'm trying to install RoR on my computer following the instructions
on
the download page
(http://rubyonrails.org/download***<http://rubyforg...
*). 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
B85d2c78cae9885b7f1ad2b5f808a450?d=identicon&s=25 Konstantin Shabanov (Guest)
on 2011-02-02 15:55
(Received via mailing list)
You need to put sqlite3.dll in the ruby bin dir or you can try
http://rubyinstaller.org/
01cc74e3257c8bcc3e4ae13274c01c8a?d=identicon&s=25 Shyam M. (shyam_m)
on 2011-02-02 15:59
(Received via mailing list)
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
561f863a41eeda3bf34ff16ba8b2486c?d=identicon&s=25 Parth B (Guest)
on 2011-02-02 16:46
(Received via mailing list)
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"*
6) In Ruby Cmd, "*rails server"*
> Error: no sqlite3.dll found, error within cmd
7) In Ruby cmd, "*bundle install*" per suggestion.
8) 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....
561f863a41eeda3bf34ff16ba8b2486c?d=identicon&s=25 Parth B (Guest)
on 2011-02-02 16:49
(Received via mailing list)
Sorry in Step 5, it was "cd C:\testApp" as that is appropriate.
9770ee3431156709c728f6105dd98f0d?d=identicon&s=25 Bosko Ivanisevic (Guest)
on 2011-02-02 18:51
(Received via mailing list)
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ć
561f863a41eeda3bf34ff16ba8b2486c?d=identicon&s=25 Parth B (Guest)
on 2011-02-04 22:25
(Received via mailing list)
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!
56c42b1ecf804b58ec7d187081cd775a?d=identicon&s=25 Dennis Rose (dennis_r)
on 2011-02-10 23:57
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!
56c42b1ecf804b58ec7d187081cd775a?d=identicon&s=25 Dennis Rose (dennis_r)
on 2011-02-11 01:47
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!
A6cb728f671c6054b3b775bb37090451?d=identicon&s=25 timmickelson (Guest)
on 2011-05-26 13:35
(Received via mailing list)
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.
--
View this message in context:
http://old.nabble.com/Install-Issue-with-sqlite3.d...
Sent from the RubyOnRails Users mailing list archive at Nabble.com.
E7cff3cfd41c495e1012227d7dc24202?d=identicon&s=25 Luis Lavena (luislavena)
on 2011-05-26 17:55
(Received via mailing list)
On May 26, 7:33am, timmickelson <timmickelso...@yahoo.com> 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 Lavena
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.