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 :price, :float
end
# create a dataset from the items table
items = DB[:items]
# populate the table
items << {:name => 'abc', :price => rand * 100}
items << {:name => 'def', :price => rand * 100}
items << {:name => 'ghi', :price => rand * 100}
# print out the number of records
puts "Item count: #{ items.count }"
# print out the records in descending order by price
items.reverse_order(:price).print
# print out the average price
puts "The average price is: #{ items.avg :price }"
------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
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
···
On Thu, Apr 16, 2009 at 4:10 PM, <jhs408@gmail.com> wrote:
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.
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
···
On Apr 16, 9:26 am, Ben Lovell <benjamin.lov...@gmail.com> wrote:
[Note: parts of this message were removed to make it a legal post.]
On Thu, Apr 16, 2009 at 4:10 PM, <jhs...@gmail.com> wrote:
> 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.
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.
···
On Thu, Apr 16, 2009 at 11:45 PM, <jhs408@gmail.com> wrote:
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.
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
···
On Apr 17, 2:30 am, Ben Lovell <benjamin.lov...@gmail.com> wrote:
[Note: parts of this message were removed to make it a legal post.]
On Thu, Apr 16, 2009 at 11:45 PM, <jhs...@gmail.com> wrote:
> 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.