Forum: Ruby Need help with SQLite3

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
282d4190e23301bbaa8a2343370a6c20?d=identicon&s=25 Joshua Collins (Guest)
on 2009-05-04 01:26
(Received via mailing list)
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?
54404bcac0f45bf1c8e8b827cd9bb709?d=identicon&s=25 7stud -- (7stud)
on 2009-05-04 02:50
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>
282d4190e23301bbaa8a2343370a6c20?d=identicon&s=25 Joshua Collins (Guest)
on 2009-05-04 03:04
(Received via mailing list)
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 :-\
9770ee3431156709c728f6105dd98f0d?d=identicon&s=25 Bosko Ivanisevic (Guest)
on 2009-05-04 08:51
(Received via mailing list)
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
Be07c8d0d6867fd9a0d525f7d17600e2?d=identicon&s=25 Damjan Rems (ther)
on 2009-05-04 11:17
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
This topic is locked and can not be replied to.