From: Luis Lavena <luislavena@...>
Date: 2009-11-28T23:45:07+09:00
Subject: Re: SQLite and Ruby DLL problem

On Nov 28, 10:04 am, Omar Campos <hypermeis...@yahoo.com> wrote:
> Hello all,
>
>   I am trying to get Ruby to work with SQLite under Windows.  I
> installed the Sqlite-ruby gem, but whenever I do this:
>
> require 'sqlite'
>
> I get an error saying that sqlite.dll was  not found.  I have downloaded
> de SQLite DLL, and placed it in the Windows folder, the system32 folder
> and inside
> C:\ruby\lib\ruby\gems\1.8\gems\sqlite-ruby-2.2.3-x86-mswin32\lib.
>
> But the error persists.  Where must I place this DLL to get SQLite to
> work?
>
> Thanks for any info.

Please follow this tutorial:

http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-sqlite3/

You don't need to install Rails, but just for you to setup a proper
Ruby version (either 1.8.6 or 1.9.1) and setup SQLite3 properly to
work with Ruby.

Note that sqlite3-ruby version 1.2.5 was released officially, so you
don't need to indicate --source at the installation command.

Please look for "RubyInstaller Release Candidate 1" and not the old
One-Click Installer packages. RubyForge sucks at the package listing
and filtering, so please pay attention to what you download.

Hope this helps,
--
Luis Lavena