# Need help with SQLite3

**URL:** <https://www.ruby-forum.com/t/need-help-with-sqlite3/167100>\
**Category:** Ruby\
**Created:** [May 4, 2009, 1:26am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100 "2009-05-04T01:26:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![syncopated](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85f322/32.png) [@syncopated](https://www.ruby-forum.com/u/syncopated)\
**Post date:** [May 4, 2009, 1:26am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100/1 "2009-05-04T01:26:22Z")

</div>

I am trying to install SQLite3

I put the required Windows32 files into my path. I installed the gem  
sqlite3-ruby successfully … but something is wrong!

I tested the installation with:

require ‘rubygems’  
require ‘sqlite3’  
puts “It’s all okay!” if defined?(SQLite3::Database)

On out put I get nothing … if all was setup ok i should get out of:

It’s all okay!

Any idea what could be causing the issue?

---

<div class="post-metadata">

**Author:** ![syncopated](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85f322/32.png) [@syncopated](https://www.ruby-forum.com/u/syncopated)\
**Post date:** [May 4, 2009, 2:50am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100/2 "2009-05-04T02:50:12Z")

</div>

Joshua C. wrote:

> I am trying to install SQLite3
> 
> I put the required Windows32 files into my path. I installed the gem  
> sqlite3-ruby successfully … but something is wrong!
> 
> I tested the installation with:
> 
> require ‘rubygems’  
> require ‘sqlite3’  
> puts “It’s all okay!” if defined?(SQLite3::Database)
> 
> On out put I get nothing … if all was setup ok i should get out of:
> 
> It’s all okay!
> 
> Any idea what could be causing the issue?

What directory was your prompt pointing at? What is the output when you  
type:

…some/path\> sqlite3

---

<div class="post-metadata">

**Author:** ![syncopated](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85f322/32.png) [@syncopated](https://www.ruby-forum.com/u/syncopated)\
**Post date:** [May 4, 2009, 3:04am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100/3 "2009-05-04T03:04:11Z")

</div>

when I type $ sqlite3

No matter the directory since it is in my path

I get the output

SQLite version 3.6.13  
Enter “.help” for instructions  
Enter SQL statements terminated with “;”  
sqlite\>

But, it seems my Ruby is not connecting to SQLite3. For instance, that  
test  
file I setup should have gave the prompted text if it returned TRUE, but  
it  
seems to have returned FALSE

So, any code I write will not interface with the database :-\

---

<div class="post-metadata">

**Author:** ![syncopated](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85f322/32.png) [@syncopated](https://www.ruby-forum.com/u/syncopated)\
**Post date:** [May 4, 2009, 8:51am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100/4 "2009-05-04T08:51:35Z")

</div>

On May 4, 3:03 am, Joshua C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Enter SQL statements terminated with “;”
> 
> > > I am trying to install SQLite3  
> > > On out put I get nothing … if all was setup ok i should get out of:  
> > > –  
> > > Posted viahttp://www.ruby-forum.com/.

Do you have sqlite3.dll in your path too?

Regards,  
Bosko

---

<div class="post-metadata">

**Author:** ![syncopated](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/85f322/32.png) [@syncopated](https://www.ruby-forum.com/u/syncopated)\
**Post date:** [May 4, 2009, 11:17am UTC](https://www.ruby-forum.com/t/need-help-with-sqlite3/167100/5 "2009-05-04T11:17:16Z")

</div>

Bosko I. wrote:

> On May 4, 3:03�am, Joshua C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Enter SQL statements terminated with “;”
> > 
> > > > I am trying to install SQLite3  
> > > > On out put I get nothing … if all was setup ok i should get out of:  
> > > > –  
> > > > Posted viahttp://www.ruby-forum.com/.
> 
> Do you have sqlite3.dll in your path too?
> 
> Regards,  
> Bosko

This has probably nothing to do with sqlite3.dll.

I guess something is wrong with sqlite3 gem. Try to uninstall it and  
install it again.

by  
TheR