Need help installing sqlite3 on windows

Ruby
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

2

greg halsey wrote:

Here is what I tried:

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 B. 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