Install SQLite 3.6 on Windows 7

Question

How to install SQLite 3.6 on Windows 7?

I extracted sqlite3.exe, sqlite3.dll and sqlite3.def in C: \ Windows \ System32, but when I try to run a Ruby program that requires using sqlite3, I get this error:

The program cannot start because sqlite3.dll is missing on your computer. Try reinstalling the program to fix this problem.

Answer 1

I would try adding the path to SQLite in PATH.

Optional: SQLite 3 is not installed. This is a DLL, usually unregistered. Most programs using SQLite 3 will rely on a local copy or one link to the environment variable.

Answer 2

Just tried this on Windows 7 Ultimate 64 bit. I didn’t like it when I put it in the ruby ​​/ bin folder. I didn’t like \ Winodws \ System32 either ... put it in \ Windows \ system and it started ... go to the figure ... anyway fyi for 64-bit.

Answer 3

Windows 7 is 64 bit here, and also, putting them in \ Windows \ system, did it for me.

I actually installed this for HDBC and Haskell according to the instructions http://wiki.github.com/jgoerzen/hdbc/frequentlyaskedquestions

The only difference for the 64-bit version of Windows 7 is in the instruction below -

"Put" sqlite3.dll "from sqlitedll-3 * .zip in ghc -print-libdir and in% windir% \ system32."

The file should be copied to \ Windows \ system instead of the% windir% \ system32 folder.

Answer 4

I had this problem when trying to run Rake (bundle exec rake db: migrate).

I tried installing PATH and copying the SqlLite binaries to C: \ Windows \ System32, but to no avail.

Finally, resolving it by copying the binaries to my Ruby bin directory (C: \ Ruby192 \ bin), based on the recommendations of this post: http://www.ruby-forum.com/topic/216270#977959 .