Forum: Ruby on Rails SQLITE3 error

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.
Barry M. (Guest)
on 2008-11-07 09:14
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
This topic is locked and can not be replied to.