First, thanks for any help from the community and to Quinton for his development efforts, I am grateful.

I'm writing to express my frustration at what seems to me to be prolific yet out of date and conflicting documentation regarding SalesForce and Rails integration.

Is the "force.com toolkit for ruby" the rforcedotcom gem?

As of today, should developers be using activesalesforce, activerecord-salesforce-adapter, or asf-soap-adapter?

I haven't been able to accomplish my simple goal: creating a Rails 3.0.4 application that allows me to execute, from the console, Salesforce::SfBase.query_by_sql("select name from Account")

rails new someapp

cd someapp

bundle install

script/console

(explosion)

Given that my Gemfile states:

source 'http://rubygems.org'

gem 'rails', '3.0.4'
gem 'sqlite3'
gem 'asf-soap-adapter'

And my database.yml states:

development:
  adapter: sqlite3
  database: db/development.sqlite3
  pool: 5
  timeout: 5000

salesforce-default-realm:
  adapter: activesalesforce
  url: https://www.salesforce.com
  username: xxx
  password: xxx
  api_version: 20.0

 And my current gemset includes only the following:

abstract (1.0.0)
actionmailer (3.0.4)
actionpack (3.0.4)
activemodel (3.0.4)
activerecord (3.0.4)
activerecord-activesalesforce-adapter (2.0.0)
activeresource (3.0.4)
activesalesforce (1.1.6)
activesupport (3.0.4)
arel (2.0.8)
asf-soap-adapter (1.3.0)
builder (2.1.2)
bundler (1.0.10)
erubis (2.6.6)
facets (2.8.4)
hpricot (0.8.3)
i18n (0.5.0)
mail (2.2.15)
mime-types (1.16)
polyglot (0.3.1)
rack (1.2.1)
rack-mount (0.6.13)
rack-test (0.5.7)
rails (3.0.4)
railties (3.0.4)
rake (0.8.7)
rforcedotcom (20.0.0)
sqlite3 (1.3.3)
thor (0.14.6)
treetop (1.4.9)
tzinfo (0.3.24)

This should freakin' work. But it doesn't. Upon executing rails console:

/Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/activerecord-3.0.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:62:in `establish_connection': salesforce-default-realm database is not configured (ActiveRecord::AdapterNotSpecified)
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/asf-soap-adapter-1.3.0/lib/salesforce/sf_base.rb:61
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/asf-soap-adapter-1.3.0/lib/asf-soap-adapter.rb:4:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/asf-soap-adapter-1.3.0/lib/asf-soap-adapter.rb:4
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:68:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:68:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:66:in `each'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:66:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:55:in `each'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler/runtime.rb:55:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/bundler-1.0.10/lib/bundler.rb:120:in `require'
	from /Users/ybakos/tmp/sftest02/config/application.rb:7
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/railties-3.0.4/lib/rails/commands.rb:21:in `require'
	from /Users/ybakos/.rvm/gems/ruby-1.8.7-p330@test/gems/railties-3.0.4/lib/rails/commands.rb:21
	from script/rails:6:in `require'
	from script/rails:6

If anyone has successfully created a skeletal Rails 3.x app and has been able to fire up the console and execute Salesforce::SfBase.query_by_sql("select name from Account")

Then please do share what steps you took, and what your Gemfile and database.yml state.