Need help installing sqlite3 on windows

ruby-talk
1

Here is what I tried:

Downloaded sqlite3.dll and placed in c:\windows\system32 (I also tried
it in c:\ruby\bin).

C:\>"c:\ruby\bin\ruby.exe" "c:\ruby\bin\gem" install -r sqlite3-ruby
Attempting remote installation of 'sqlite3-ruby'
Select which gem to install for your platform (i386-mswin32)
1. sqlite3-ruby 1.1.0 (mswin32)
2. sqlite3-ruby 1.1.0 (ruby)
3. sqlite3-ruby 1.0.1 (ruby)
4. sqlite3-ruby 1.0.1 (mswin32)
5. sqlite3-ruby 1.0.0 (mswin32)
6. sqlite3-ruby 1.0.0 (ruby)
7. sqlite3-ruby 0.9.0 (ruby)
8. sqlite3-ruby 0.9.0 (mswin32)
9. sqlite3-ruby 0.6.0 (ruby)
10. sqlite3-ruby 0.5.0 (ruby)
11. Cancel installation

1

Successfully installed sqlite3-ruby-1.1.0-mswin32
Installing RDoc documentation for sqlite3-ruby-1.1.0-mswin32...

lib/sqlite3/database.rb:637:65: Skipping require of dynamic string:
"sqlite3/dri
ver/#{driver.to_s.downcase}/driver"

lib/sqlite3/database.rb:642:59: Skipping require of dynamic string:
"sqlite3/dri
ver/#{d.downcase}/driver"

C:\>irb
irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0>

It doesn't seem to want to load.

I can get it to work through the ODBC driver, but it doesn't seem like
the best way to use sqlite3.

-thanks

···

--
Posted via http://www.ruby-forum.com/\.

2

greg halsey wrote:

Here is what I tried:
<snip>

A successful installation.

C:\>irb
irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0>

It doesn't seem to want to load.

It loaded. The return value of require doesn't mean much. Try this:

irb(main):002:0> SQLite3
=> SQLite3

See, the class is there, you're good to go.

Cheers,
Dave

3

Dave Burt wrote:

C:\>irb
irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0>

It loaded. The return value of require doesn't mean much. Try this:

irb(main):002:0> SQLite3
=> SQLite3

See, the class is there, you're good to go.

Cheers,
Dave

Looking at the post I noticed the code should have the first two letters
uppercase.

irb(main):001:0> require 'SQlite3'
=> true

Time to try it out.
Thanks

···

--
Posted via http://www.ruby-forum.com/\.