Hi I''m triying to begin developing in ruby on rails, and I''ve instaled all the components but there is a problem with the file sqlite3.dll. When I try to execute my first example in my web browser apears an alert that says sqlite3.dll is not found. I''m working on windows XP with firefox and the server is WEBrick. If someone knows how can I resolve the problem please response. Thanks for reading :) Attachments: http://www.ruby-forum.com/attachment/1725/ruby_error.GIF -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Iñaki Garcia wrote:> Hi I''m triying to begin developing in ruby on rails, and I''ve instaled > all the components but there is a problem with the file sqlite3.dll. > When I try to execute my first example in my web browser apears an alert > that says sqlite3.dll is not found. > I''m working on windows XP with firefox and the server is WEBrick. > > If someone knows how can I resolve the problem please response. > Thanks for reading :)You must put sqlite3.dll file into directory c:\windows\system32 klodus -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Klodus Klodus wrote: | | You must put sqlite3.dll file into directory c:\windows\system32 No, no, no. You must not put anything into %windir%\system32, ever. It is enough if the sqlite3.dll is somewhere in your path. It''s best if it is in the lib dir of the SQLite3 gem. In my case that would be: C:\dev\ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.1-x86-mswin32\lib (notice that the sqlite3_api.so is residing there, too). - -- Phillip Gawlowski Twitter: twitter.com/cynicalryan ~ "You don''t get to be mom if you can''t fix everything just right." - -Calvin -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkgBT4gACgkQbtAgaoJTgL+nXQCeODKcso3veWInghaii11rEaz3 jzYAmQHz3Bx95Bzy67Lfm4QvUEbK9ECH =B01o -----END PGP SIGNATURE----- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Klodus Klodus wrote: > > | > | You must put sqlite3.dll file into directory c:\windows\system32 > > No, no, no. You must not put anything into %windir%\system32, ever. > > It is enough if the sqlite3.dll is somewhere in your path. It''s best if > it is in the lib dir of the SQLite3 gem. > > In my case that would be: > C:\dev\ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.1-x86-mswin32\lib > (notice that the sqlite3_api.so is residing there, too). > > - -- > Phillip Gawlowski > Twitter: twitter.com/cynicalryan > > ~ "You don''t get to be mom if you can''t fix everything just right." > - -Calvin > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.8 (MingW32) > Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org > > iEYEARECAAYFAkgBT4gACgkQbtAgaoJTgL+nXQCeODKcso3veWInghaii11rEaz3 > jzYAmQHz3Bx95Bzy67Lfm4QvUEbK9ECH > =B01o > -----END PGP SIGNATURE-------~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thanks it''s finally working -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
@Phillip Gawlowski Personnally, it did not work to put sqlite3.dll in \ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.1-x86-mswin32\lib nor \ruby\gems\1.8\gems\sqlite3-ruby-1.2.5-x86-mingw32\lib\1.8 where there is sqlite3_api.so nor \ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.5-x86-mingw32\lib\sqlite3\driver\dl where there is api.rb Finally I put it in /ruby/bin/ ... H http://harryseldon.thinkosphere.com -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Just curious why it wouldn''t be installed when you type gem install... and maybe helping to post where to get it since it doesn''t come with the install Harry Seldon wrote:> @Phillip Gawlowski > Personnally, it did not work to put sqlite3.dll in > \ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.1-x86-mswin32\lib > nor > \ruby\gems\1.8\gems\sqlite3-ruby-1.2.5-x86-mingw32\lib\1.8 > where there is sqlite3_api.so > nor > \ruby\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.5-x86-mingw32\lib\sqlite3\driver\dl > where there is api.rb > > Finally I put it in /ruby/bin/ ... > > H > http://harryseldon.thinkosphere.com-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
this link doesn''t work Carlos Aguayo wrote:> http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite > > On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org>-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Will Kriski wrote:> this link doesn''t work > > Carlos Aguayo wrote: >> http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite >> >> On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org>Hi,In my case I use Ruby 1.9.1 OS is WindowsXP SP3 Solution 1.Go to http://www.sqlite.org/download.html and Download file sqlitedll-3_7_0_1.zip (265.19 KiB) unzip then we will get sqlite3.dll 2.copy sqlite3.dll to your bin folder as C:\Ruby191\bin then it works armoilla -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Thanks @Armoilla for this nice solution. Yes, it works. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
This doesn''t seem to be working for me. Ruby 1.9.2 Windows XP I have the sqlite3.dll in my ruby/bin dir but I still get the error "The procedure entry point sqlite3_column_database_name could not be located in the dynamic link library sqlite3.dll." when I run " rails server" from the command prompt. Any ideas? I tried putting the .dll in both system32 and the other lib folder as suggested in this thread. Thanks! Andre Armoilla Armoilla wrote:> Will Kriski wrote: >> this link doesn''t work >> >> Carlos Aguayo wrote: >>> http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite >>> >>> On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> > > Hi,In my case > I use Ruby 1.9.1 > OS is WindowsXP SP3 > > Solution > 1.Go to http://www.sqlite.org/download.html > and Download file sqlitedll-3_7_0_1.zip (265.19 KiB) > unzip then we will get sqlite3.dll > 2.copy sqlite3.dll to your bin folder as C:\Ruby191\bin > then it works > > armoilla-- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Sep 24, 6:56 pm, Andre Sisdotivitz <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> This doesn''t seem to be working for me. > > Ruby 1.9.2 > Windows XP > > I have the sqlite3.dll in my ruby/bin dir but I still get the error > "The procedure entry point sqlite3_column_database_name could not be > located in the dynamic link library sqlite3.dll." when I run " rails > server" from the command prompt. > > Any ideas? >That indicates the dll is from a old version of sqlite3. Please try to use SQLite 3.6.16 or greater, as indicated by the gem install sqlite3- ruby: C:\Users\Luis>gem install sqlite3-ruby Temporarily enhancing PATH to include DevKit... ============================================================================ You''ve installed the binary version of sqlite3-ruby. It was built using SQLite3 version 3.6.23.1. 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_6_23_1.zip You can put the sqlite3.dll available in this package in your Ruby bin directory, for example C:\Ruby\bin ============================================================================ Successfully installed sqlite3-ruby-1.3.1-x86-mingw32 1 gem installed> I tried putting the .dll in both system32 and the other lib folder as > suggested in this thread. >Do not put files in system32, XP is not Windows 3.1 -- Luis Lavena -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
also you can read http://www.juan-capristan.net/blog/?p=173 for an explanation an guidance -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.