Rick,
You can find detailed installation and configuration information at http://odbc-rails.rubyforge.org.
After installing the gem, enable loading of the adapter by editing your Rails project's config/environment.rb script: * Add a require to your config/environment.rb immediately after the line require File.join(File.dirname(__FILE__), 'boot') i.e. require File.join(File.dirname(__FILE__), 'boot') require 'odbc_adapter'
You'll need to define an ODBC DSN for your data source, then reference this in your database.yml file. Your database.yml file should contain something similar to:
development: adapter: odbc dsn: b606_vos_localhost_rails_dev username: rails_dev password: rails_dev emulate_booleans: true trace: false
with a similar entry for your test: environment.
The emulate_booleans entry isn't needed if the database has a native BOOLEAN type. See the 'Usage Information' and 'Database Specific Notes' sections of http://odbc-rails.rubyforge.org.
The odbc-rails gem includes detailed RDoc information. (Run gem_server and point your browser to http://localhost:8808 to see the local RDoc documentation)
Also, ensure you set the RUBYOPT environment variable: set RUBYOPT=-rubygems Otherwise you may see a "undefined method `cattr_accessor'" error message.
Hope this helps
Carl Blakeley