# Need help with SQLite3 **URL:** \ **Category:** ruby-talk\ **Created:** [3 May 2009 23:25 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192 "2009-05-03T23:25:29Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Joshua\_Collins1](https://avatars.discourse-cdn.com/v4/letter/j/839c29/32.png) [@Joshua\_Collins1](https://rubytalk.org/u/Joshua_Collins1)\ **Post date:** [3 May 2009 23:25 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192/1 "2009-05-03T23:25:29Z")
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? ---
**Author:** ![7stud](https://avatars.discourse-cdn.com/v4/letter/7/57b2e6/32.png) [@7stud](https://rubytalk.org/u/7stud)\ **Post date:** [4 May 2009 00:50 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192/2 "2009-05-04T00:50:14Z")
Joshua Collins 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 \ > **···** > > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Joshua\_Collins1](https://avatars.discourse-cdn.com/v4/letter/j/839c29/32.png) [@Joshua\_Collins1](https://rubytalk.org/u/Joshua_Collins1)\ **Post date:** [4 May 2009 01:03 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192/3 "2009-05-04T01:03:30Z")
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 ";" > 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 :-\ > **···** > > On Sun, May 3, 2009 at 8:50 PM, 7stud -- \ wrote: > > > Joshua Collins 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 \ > > > > -- > > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C). ---
**Author:** ![Bosko\_Ivanisevic](https://avatars.discourse-cdn.com/v4/letter/b/43a26b/32.png) [@Bosko\_Ivanisevic](https://rubytalk.org/u/Bosko_Ivanisevic)\ **Post date:** [4 May 2009 06:50 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192/4 "2009-05-04T06:50:08Z")
Do you have sqlite3.dll in your path too? Regards, Bosko > **···** > > On May 4, 3:03 am, Joshua Collins \ wrote: > > > [Note: parts of this message were removed to make it a legal post.] > > > > 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 ";" > > \> > > > > 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 :-\ > > > > On Sun, May 3, 2009 at 8:50 PM, 7stud -- \ wrote: > > \> Joshua Collins 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 \ > > > > \> -- > > \> Posted viahttp://www.ruby-forum.com/. ---
**Author:** ![Damjan\_Rems](https://avatars.discourse-cdn.com/v4/letter/d/65b543/32.png) [@Damjan\_Rems](https://rubytalk.org/u/Damjan_Rems)\ **Post date:** [4 May 2009 09:17 UTC](https://rubytalk.org/t/need-help-with-sqlite3/53192/5 "2009-05-04T09:17:18Z")
Bosko Ivanisevic wrote: > **···** > > > On May 4, 3:03�am, Joshua Collins \ 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 > -- > Posted via [http://www.ruby-forum.com/\](http://www.ruby-forum.com/%5C).