Sqlite driver not found on windows

I faced the same problem as below. Does anyone have any solutions? Ruby cannot find sqlite3 driver in windows I installed Ruby 1.9.1 then rails.Then I installed sqlite3-ruby but it is broken. So I deleted the directory and installed sqlite3-ruby for win version 1.2.3. But after getting the error "sqlite driver not found"

0


source to share


2 answers


I had the same problem.

sqlite3-ruby version 1.2.3 seems incompatible with Ruby 1.9. Version 1.2.4 is (possibly) compatible, but a Windows binary was not released and the maintainer announced that he was no longer building and releasing for windows.



According to this post, someone is working on a fix, but it doesn't exist yet.

So this would be a useless answer as so far none of my research has found a fix that is available now. The options for installing Windows Ruby / Rails today are either migrating to MySQL for the development database or migrating to Ruby 1.8.7.

+1


source


You need to install the actual sqlite3.dll for Windows.

Go to http://www.sqlite.org/download.html and download sqlitedll-3_6_13.zip and sqlite-3_6_13.zip (or any other versions).



Unzip both of these zip files. Copy sqlite3.exe to c: \ windows and sqlite3.dll to c: \ windows \ system32

Run gem install sqlite3-ruby --no-ri --no-rdoc --version = 1.2.3 --platform = mswin32 from the command line to install the SQLite3 gem (additional flags prevent it from compiling some things that are not normally available in Windows)

0


source







All Articles