cannot load such file — sqlite3/sqlite3_native (Lo

Question

I am getting the above error when trying to run rails s.

bundle show sqlite3 produces

c:/ruby/lib/ruby/gems/2.0.0/gems/sqlite3-1.3.7-x86-mingw32 (which means, gasp, I'm running it on a Windows XP machine.)

I also have:

group :development, :test do
  ...
  gem 'sqlite3'
  ...
end

I haven't found any other answers similar (environment-wise) to this one. Any help?

Answer 1

Had the same problem. This won't directly answer your question but I solved it by simply installing the whole set using http://railsinstaller.org/ and it all works

Following are all the packages installed by railsinstaller:

• Ruby 1.9.3-p392
• Rails 3.2
• Bundler
• Git
• Sqlite
• TinyTDS
• SQL Server
• Support
• DevKit

Answer 2

I had the same problem and a hard time to solve it. I was helped by these page knapsack sqlite installer from Luis Lavena and this one https://github.com/luislavena/sqlite3-ruby/issues/82

The first page was almost all right except I had this error :

checking for sqlite3_libversion_number() in -lsqlite3... no

The second link which gave me the solution; instead of

c:\sqlite3x86>gem install sqlite3 --platform=ruby --  --with-sqlite3-dir=C:/sqlite3x86

I had to type

c:\sqlite3x86>gem install sqlite3 --platform=ruby --  --with-sqlite3-lib=C:/sqlite3x86/lib --with-sqlite3-include=C:/sqlite3x86/include

As you might have guessed, I put the knapsack sqlite3 build by Luis Lavena in a directory called sqlite3x86