# Need help installing sqlite3 on windows

**URL:** <https://www.ruby-forum.com/t/need-help-installing-sqlite3-on-windows/61089>\
**Category:** Ruby\
**Created:** [May 20, 2006, 12:25am UTC](https://www.ruby-forum.com/t/need-help-installing-sqlite3-on-windows/61089 "2006-05-20T00:25:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [May 20, 2006, 12:25am UTC](https://www.ruby-forum.com/t/need-help-installing-sqlite3-on-windows/61089/1 "2006-05-20T00:25:03Z")

</div>

Here is what I tried:

Downloaded sqlite3.dll and placed in c:\windows\system32 (I also tried  
it in c:\ruby\bin).

C:\>“c:\ruby\bin\ruby.exe” “c:\ruby\bin\gem” install -r sqlite3-ruby  
Attempting remote installation of ‘sqlite3-ruby’  
Select which gem to install for your platform (i386-mswin32)

1. sqlite3-ruby 1.1.0 (mswin32)
2. sqlite3-ruby 1.1.0 (ruby)
3. sqlite3-ruby 1.0.1 (ruby)
4. sqlite3-ruby 1.0.1 (mswin32)
5. sqlite3-ruby 1.0.0 (mswin32)
6. sqlite3-ruby 1.0.0 (ruby)
7. sqlite3-ruby 0.9.0 (ruby)
8. sqlite3-ruby 0.9.0 (mswin32)
9. sqlite3-ruby 0.6.0 (ruby)
10. sqlite3-ruby 0.5.0 (ruby)
11. Cancel installation

> 1  
> Successfully installed sqlite3-ruby-1.1.0-mswin32  
> Installing RDoc documentation for sqlite3-ruby-1.1.0-mswin32…

lib/sqlite3/database.rb:637:65: Skipping require of dynamic string:  
“sqlite3/dri  
ver/#{driver.to\_s.downcase}/driver”

lib/sqlite3/database.rb:642:59: Skipping require of dynamic string:  
“sqlite3/dri  
ver/#{d.downcase}/driver”

C:\>irb  
irb(main):001:0\> require ‘sqlite3’  
=\> false  
irb(main):002:0\>

It doesn’t seem to want to load.

I can get it to work through the ODBC driver, but it doesn’t seem like  
the best way to use sqlite3.

-thanks

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [May 20, 2006, 12:37am UTC](https://www.ruby-forum.com/t/need-help-installing-sqlite3-on-windows/61089/2 "2006-05-20T00:37:24Z")

</div>

greg halsey wrote:

> Here is what I tried:

A successful installation.

> C:\>irb  
> irb(main):001:0\> require ‘sqlite3’  
> =\> false  
> irb(main):002:0\>
> 
> It doesn’t seem to want to load.

It loaded. The return value of require doesn’t mean much. Try this:

irb(main):002:0\> SQLite3  
=\> SQLite3

See, the class is there, you’re good to go.

Cheers,  
Dave

---

<div class="post-metadata">

**Author:** ![greg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/71c47a/32.png) [@greg](https://www.ruby-forum.com/u/greg)\
**Post date:** [May 20, 2006, 5:42am UTC](https://www.ruby-forum.com/t/need-help-installing-sqlite3-on-windows/61089/3 "2006-05-20T05:42:03Z")

</div>

Dave B. wrote:

> > C:\>irb  
> > irb(main):001:0\> require ‘sqlite3’  
> > =\> false  
> > irb(main):002:0\>  
> > It loaded. The return value of require doesn’t mean much. Try this:
> 
> irb(main):002:0\> SQLite3  
> =\> SQLite3
> 
> See, the class is there, you’re good to go.
> 
> Cheers,  
> Dave

Looking at the post I noticed the code should have the first two letters  
uppercase.

irb(main):001:0\> require ‘SQlite3’  
=\> true

Time to try it out.  
Thanks