gistfile1.txt

c:\>gem -v
1.3.7

c:\>ruby -v
ruby 1.9.2dev (2010-05-31) [i386-mingw32]

c:\>irb
irb(main):001:0> require 'sqlite3'
LoadError: no such file to load -- sqlite3/sqlite3_native
        from c:/ruby/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.3.0-x86-mingw32/lib/sqlite3.rb:6:in `require'
        from c:/ruby/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.3.0-x86-mingw32/lib/sqlite3.rb:6:in `rescue in <top (required)>'
        from c:/ruby/ruby-1.9.2/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.3.0-x86-mingw32/lib/sqlite3.rb:2:in `<top (required)>'
        from (irb):1:in `require'
        from (irb):1
        from c:/ruby/ruby-1.9.2/bin/irb:12:in `<main>'
irb(main):002:0> 

Do you have sqlite3.dll version 3.6.22 in the PATH?

I couldn't reproduce this error using 1.9.2-preview3

Hi,
I downloaded the following sqlite3 dll: http://www.sqlite.org/sqlitedll-3_6_23_1.zip. I extracted and copied the library into Ruby's bin folder and everything works now. It is really expected behaviour? I don't think so.