# Ruby sqlite/gem error: Could not load sqlite adapter **URL:** \ **Category:** Ruby\ **Created:** [April 16, 2009, 5:11pm UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712 "2009-04-16T17:11:03Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\ **Post date:** [April 16, 2009, 5:11pm UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712/1 "2009-04-16T17:11:03Z")
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 ---
**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\ **Post date:** [April 16, 2009, 6:27pm UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712/2 "2009-04-16T18:27:23Z")
On Thu, Apr 16, 2009 at 4:10 PM, [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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. Ben ---
**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\ **Post date:** [April 17, 2009, 12:47am UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712/3 "2009-04-17T00:47:45Z")
On Apr 16, 9:26 am, Ben L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > 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 ---
**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\ **Post date:** [April 17, 2009, 11:31am UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712/4 "2009-04-17T11:31:09Z")
On Thu, Apr 16, 2009 at 11:45 PM, [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > 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. ---
**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\ **Post date:** [April 18, 2009, 2:56am UTC](https://www.ruby-forum.com/t/ruby-sqlite-gem-error-could-not-load-sqlite-adapter/165712/5 "2009-04-18T02:56:02Z")
On Apr 17, 2:30 am, Ben L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > when the sample is executed from c:\tmp > > 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