# gem install sqlite3-ruby problem ,please help.... **URL:** \ **Category:** rubyonrails-talk\ **Created:** [December 28, 2007, 11:58pm UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368 "2007-12-28T23:58:54Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Uwe](https://avatars.discourse-cdn.com/v4/letter/u/c57346/32.png) [@Uwe](https://discuss.rubyonrails.org/u/Uwe)\ **Post date:** [December 28, 2007, 11:58pm UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/1 "2007-12-28T23:58:54Z")
sudo apt-get install sqlite3 libsqlite3-dev sudo gem install sqlite3-ruby works!! ---
**Author:** ![Phillip\_Koebbe](https://avatars.discourse-cdn.com/v4/letter/p/d9b06d/32.png) [@Phillip\_Koebbe](https://discuss.rubyonrails.org/u/Phillip_Koebbe)\ **Post date:** [December 29, 2007, 12:08am UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/2 "2007-12-29T00:08:01Z")
Yes, when you install many gems, they get built natively, so you need development libraries for that to work correctly. Peace, Phillip ---
**Author:** ![Luc\_Evers](https://avatars.discourse-cdn.com/v4/letter/l/aeb1de/32.png) [@Luc\_Evers](https://discuss.rubyonrails.org/u/Luc_Evers)\ **Post date:** [December 29, 2007, 10:55am UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/3 "2007-12-29T10:55:11Z")
Hi, I’m using Suse10.3, with yast you can install the sqlite3 gem + yast shall automatic install all other libs you need. No problem with Suse. Luc. ---
**Author:** ![Thufir](https://avatars.discourse-cdn.com/v4/letter/t/ee7513/32.png) [@Thufir](https://discuss.rubyonrails.org/u/Thufir)\ **Post date:** [December 30, 2007, 10:09am UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/4 "2007-12-30T10:09:51Z")
What about on windows? -Thufir ---
**Author:** ![Luc\_Evers](https://avatars.discourse-cdn.com/v4/letter/l/aeb1de/32.png) [@Luc\_Evers](https://discuss.rubyonrails.org/u/Luc_Evers)\ **Post date:** [December 30, 2007, 4:16pm UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/5 "2007-12-30T16:16:10Z")
Thufir, For Windows try: _ **Source:** _[http://www.artima.com/forums/flat.jsp?forum=123&thread=140416](http://www.artima.com/forums/flat.jsp?forum=123&thread=140416) 1. Install SQLite3 for Windows by downloading the following 2 zip files and unzipping them into /WINDOWS/system32 [http://www.sqlite.org/sqlite-3\_2\_7.zip](http://www.sqlite.org/sqlite-3_2_7.zip) [http://www.sqlite.org/sqlitedll-3\_2\_7.zip](http://www.sqlite.org/sqlitedll-3_2_7.zip) [If those don’t work try the official download site here](http://www.sqlite.org/download.html) 1. gem install sqlite3-ruby 2. Select option 1 to get the latest win32 driver Read: [Installing SQLite 3 on Windows](http://jroller.com/page/obie?entry=installing_sqlite_3_on_windows) ---
**Author:** ![Thufir](https://avatars.discourse-cdn.com/v4/letter/t/ee7513/32.png) [@Thufir](https://discuss.rubyonrails.org/u/Thufir)\ **Post date:** [December 30, 2007, 9:52pm UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/6 "2007-12-30T21:52:00Z")
I'm not on Windows at the moment. I put the DLL into /WINDOWS/System32/ but just put the binary into C:\sqlite\... and then added the location of the binary to the PATH variable through sysdm.cpl, could this be a problem? I was getting some annoying errors when running an app on the Windows system (after putting the require 'rubygems' into the .rb files). Not a rails app, but it was using ActiveRecord and sqlite. In Windows, I could get into sqlite3 through the command line easily, and the sqlite add-on for Firefox worked fine. -Thufir ---
**Author:** ![Frederick\_Cheung](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/frederick_cheung/32/3901_2.png) [@Frederick\_Cheung](https://discuss.rubyonrails.org/u/Frederick_Cheung)\ **Post date:** [June 4, 2009, 5:21pm UTC](https://discuss.rubyonrails.org/t/gem-install-sqlite3-ruby-problem-please-help/22368/7 "2009-06-04T17:21:50Z")
Ask gem to install version 1.2.3 (since that one is available as a prebuilt win32 gem) Fred