SQLITE3 error


#1

I keep getting the following error when trying to use sqlite3 with Ruby.

“./sqlite3.dll: 127: The specified procedure could not be found. -
Init_sqlite3 (LoadError)
./sqlite3.dll from
C:/Ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require’ …”

I’m using Windows XP.
I tried reinstalling:
ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32]
rubygems 1.3.1
sqlite3.dll and sqlite3.def from sqlite.org, version 3.6.4.

The ruby program I’m running is:

require “rubygems”
require “activerecord”
ActiveRecord::Base.establish_connection(:adapter => “sqlite3”, :database
=> “test.sqlite”)
class Account < ActiveRecord::Base
end
account = Account.new
account.username = “cpytel”
account.save

Does anyone have any suggestions? This error message appeared before in
this forum, and the cure was to update the code. I am using more recent
versions than were available then.

–Barry