Need help with SQLite3

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?

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 <return>

···

--
Posted via http://www.ruby-forum.com/\.

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 -- <bbxx789_05ss@yahoo.com> 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 <return>

--
Posted via http://www.ruby-forum.com/\.

Do you have sqlite3.dll in your path too?

Regards,
Bosko

···

On May 4, 3:03 am, Joshua Collins <kidg...@gmail.com> 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 -- <bbxx789_0...@yahoo.com> 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 <return>

> --
> Posted viahttp://www.ruby-forum.com/.

Bosko Ivanisevic wrote:

···

On May 4, 3:03�am, Joshua Collins <kidg...@gmail.com> 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/\.