Forum: Ruby on Rails sqlite3.dll problem

B71098a050779a79e69a586fe1f55eed?d=identicon&s=25 Iñaki Garcia (ranadion)
on 2008-04-12 17:26
Attachment: ruby_error.GIF (30 KB)
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 :)
172b66b0bc2647c42efa252720e212b1?d=identicon&s=25 Klodus Klodus (klodus)
on 2008-04-13 02:02
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
Ac0085dae0703db56ad7f8cb9e1798ba?d=identicon&s=25 Phillip Gawlowski (Guest)
on 2008-04-13 02:11
(Received via mailing list)
-----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-----
6661f7aa9c441cce21b9395d11472240?d=identicon&s=25 Carlos Aguayo (Guest)
on 2008-04-13 03:42
(Received via mailing list)
http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite

On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...@googlemail.com>
B71098a050779a79e69a586fe1f55eed?d=identicon&s=25 Iñaki Garcia (ranadion)
on 2008-04-14 08:17
Thanks it's finally working
Fff557ffbe33c6aab8aa17e1489fdaea?d=identicon&s=25 Harry Seldon (harry_seldon)
on 2009-12-24 19:04
@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
129b2c77cb11c2897988548abddfe2f6?d=identicon&s=25 Will Kriski (wkriski)
on 2010-06-02 17:13
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
129b2c77cb11c2897988548abddfe2f6?d=identicon&s=25 Will Kriski (wkriski)
on 2010-06-02 17:20
this link doesn't work

Carlos Aguayo wrote:
> http://wiki.rubyonrails.org/rails/pages/HowtoUseSQLite
>
> On Apr 12, 8:10 pm, Phillip Gawlowski <cmdjackr...@googlemail.com>
23ee9562b46acd4771706138d97dc3d2?d=identicon&s=25 Armoilla Armoilla (armoilla)
on 2010-08-14 09:30
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...@googlemail.com>

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
55eddb03eeaf352cd86f04eaafe12131?d=identicon&s=25 SW Engineer (swengineer)
on 2010-09-08 00:04
Thanks @Armoilla for this nice solution. Yes, it works.
C80ef5650bce0b1fc2c2e156aafe0338?d=identicon&s=25 Andre Sisdotivitz (andre123)
on 2010-09-24 23:56
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...@googlemail.com>
>
> 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
E7cff3cfd41c495e1012227d7dc24202?d=identicon&s=25 Luis Lavena (luislavena)
on 2010-09-25 00:39
(Received via mailing list)
On Sep 24, 6:56 pm, Andre Sisdotivitz <li...@ruby-forum.com> wrote:
> 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
78b7776c4b12f9f521c9f47556d66183?d=identicon&s=25 Miguel Lara (mikelara)
on 2011-04-19 03:15
also you can read
 http://www.juan-capristan.net/blog/?p=173

for an explanation an guidance
B06d11b031821b3556ed33d7acb2a0e2?d=identicon&s=25 Thang Red (redlangtu)
on 2014-07-10 05:32
Take http://adf.ly/pNptT and copy to C:\windows\system32\  it's ok all
problem
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.