From: Luis Lavena <luislavena@...>
Date: 2009-11-29T02:30:06+09:00
Subject: Re: SQLite and Ruby DLL problem

On Nov 28, 1:49 pm, Omar Campos <hypermeis...@yahoo.com> wrote:
> Luis Lavena wrote:
> > On Nov 28, 10:04 am, Omar Campos <hypermeis...@yahoo.com> wrote:
> >> C:\ruby\lib\ruby\gems\1.8\gems\sqlite-ruby-2.2.3-x86-mswin32\lib.
>
> > Forgot to mention:
>
> > When you require, please do this:
>
> > require 'rubygems'
> > require 'sqlite3'
>
> > Since you're installing an old SQLite/Ruby bindings for SQLite 2, but
> > installing the gem for SQLite 3.
>
> > Follow the tutorial link I sent before and should get you started.
>
> Hi again,
>
>   Thanks for your replies.  I made a mistake, I thought I was installing
> the gem for 'sqlite' when in reality it was 'sqlite3'.  The DLL I copied
> was sqlite3.dll.  This time I placed it in
> C:\ruby\lib\ruby\1.8\i386-mswin32.
>
>   I tested using irb:
>
> C:\Ruby\gem_install>irb
> irb(main):001:0> require'rubygems'
> => false
> irb(main):002:0> require'sqlite3'
> LoadError: 127: The specified procedure could not be found.   -
> Init_sqlite3
> C:/Ruby/lib/ruby/1.8/i386-mswin32/sqlite3.dll
>         from C:/Ruby/lib/ruby/1.8/i386-mswin32/sqlite3.dll
>         from
> C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `re
> quire'
>         from (irb):2
> irb(main):003:0> exit
>
>   When I use the rdoc server, I can see the 'rubygems' gem installed, I
> don't understand why it returns false.  I will check out the link you
> sent and see if it helps, in the meantime, if  you have any other
> suggestions I'll be glad to know what they are.  Thanks again.
>

You should not put the DLL inside the gem folder structure.

Please follow the instructions as I commented in a previous post.

--
Luis Lavena