Ruby sqlite/gem error: Could not load sqlite adapter

[jhs408]

The sample "c:\tmp'Test_sqlite.rb" generates the error: Could not
load sqlite adapter,
Yet, when the example is executed in the sqlite3-ruby directory, no
error occur.

Any suggestion or changes to the sample to resolve the error.

Thanks for the help,
John
------------------------------------
Windows XP SP3
Using ruby 1.8.7, gem 1.3.2, sqlite3-ruby 1.2.4, sqlite3
product
Environment set: RUBYOPT=rubygems
PATH=c:\tools\sqlite3 ...

-----running sample----> c:\tmp\test_sqlite.rb --------------
require 'sequel'
DB = Sequel.sqlite("test-sequel.db")
# create an items table
DB.create_table :items do
primary_key :id
column :name, :text
column rice, :float
end
# create a dataset from the items table
items = DB[:items]
# populate the table
items << {:name => 'abc', rice => rand * 100}
items << {:name => 'def', rice => rand * 100}
items << {:name => 'ghi', rice => rand * 100}
# print out the number of records
puts "Item count: #{ items.count }"
# print out the records in descending order by price
items.reverse_orderprice).print
# print out the average price
puts "The average price is: #{ items.avg rice }"

------Error Msg----
C:\tmp>test_sequel.rb
C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/sequel_core/
database.rb:105:in `adapter_class': Could not load sqlite a
dapter: (Sequel::Error::AdapterNotFound)
no such file to load -- sqlite3
from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/
sequel_core/database.rb:141:in `connect'
from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/
sequel_core.rb:68:in `connect'
from C:/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/
sequel_core.rb:157:in `adapter_method'
from (eval):1:in `sqlite'
from C:/tmp/test_sequel.rb:7

 

[Ben Lovell]

[Note: parts of this message were removed to make it a legal post.]

The sample "c:\tmp'Test_sqlite.rb" generates the error: Could not
load sqlite adapter,
Yet, when the example is executed in the sqlite3-ruby directory, no
error occur.

Any suggestion or changes to the sample to resolve the error.

I may be mistaken but I'm pretty sure you have to put the sqlite3.dll (or
other binaries depending on your version) in your c:\windows\system32
directory. Give that a try.

Ben

 

[jhs408]

[Note:  parts of this message were removed to make it a legal post.]

The sample  "c:\tmp'Test_sqlite.rb"   generates the error: Could not
load sqlite adapter,
Yet, when the example is executed in the sqlite3-ruby directory,  no
error occur.

Any suggestion or changes to the sample to resolve the error.

I may be mistaken but I'm pretty sure you have to put the sqlite3.dll (or
other binaries depending on your version) in your c:\windows\system32
directory. Give that a try.

Ben

Ben,

The sqlite3.dll is located in a directory located in the PATH.
It appears that rubygems is not able to locate sqlite.rb in the
directory:C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0\lib\sequel
\adapters
when the sample is executed from c:\tmp

Yet when I place the sample in the directory:
C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0
the sample program executes correctly.

Which leads me to conclude that rubygem is having a problem.

John

 

[Ben Lovell]

[Note: parts of this message were removed to make it a legal post.]

The sqlite3.dll is located in a directory located in the PATH.
It appears that rubygems is not able to locate sqlite.rb in the
directory:C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0\lib\sequel
\adapters
when the sample is executed from c:\tmp

Yet when I place the sample in the directory:
C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0
the sample program executes correctly.

Which leads me to conclude that rubygem is having a problem.

John

Ah, just a hunch but are you certain this isn't an issue with permissions?
Try running it from an elevated command prompt if you haven't already.

 

[jhs408]

[Note:  parts of this message were removed to make it a legal post.]

The sqlite3.dll is located in a directory located in the PATH.
It appears that rubygems is not able to locate sqlite.rb in the
directory:C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0\lib\sequel
\adapters
when the sample is executed from c:\tmp

Yet when I place the sample in the directory:
C:\Ruby\lib\ruby\gems\1.8\gems\sequel-2.12.0
the sample program executes correctly.

Which leads me to conclude that rubygem is having a problem.

John

Ah, just a hunch but are you certain this isn't an issue with permissions?
Try running it from an elevated command prompt if you haven't already.

Sample problem was run in the directory c:\tmp in a command window
with admin privilage. I am beginning to suspect that there is
a rubygem problem with something specified in this example or sequel
gem which
caused the error message.

Maybe the rubygem developers might have an idea.
Appreciate the help.
John