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
on 2011-02-02 15:45
on 2011-02-02 15:55
You need to put sqlite3.dll in the ruby bin dir or you can try http://rubyinstaller.org/
on 2011-02-02 15:59
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
on 2011-02-02 16:46
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....
on 2011-02-02 16:49
Sorry in Step 5, it was "cd C:\testApp" as that is appropriate.
on 2011-02-02 18:51
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ć
on 2011-02-04 22:25
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!
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!
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!
on 2011-05-26 13:35
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.
on 2011-05-26 17:55
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