Installing SQL Server Adapter as Gem for Rails 2.0

rubyonrails-talk
1

Hello,

I just installed the SQL Server Adapter Gem from gems.rubyonrails.org for my new Rails 2.0 project:

gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org

When I attempt to use it, I receive this error message:

TypeError: superclass mismatch for class SQLServerAdapter         from /var/lib/gems/1.8/gems/activerecord-sqlserver- adapter-1.0.0/lib/active_record/connection_adapters/ sqlserver_adapter.rb:190         from /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'         from /usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'         from /home/sladd/development/workspace/DSES2/vendor/rails/ activerecord/lib/../../activesupport/lib/active_support/ dependencies.rb:496:in `require'         from /home/sladd/development/workspace/DSES2/vendor/rails/ activerecord/lib/../../activesupport/lib/active_support/ dependencies.rb:342:in `new_constants_in'

Any ideas? My database.yml looks like this:

development:   adapter: sqlserver   mode: odbc   dsn: dses_rollup   username: sa   password:

Has anyone successfully installed the new SQL Server adapter as a gem into a Rails 2.0 project?

Thanks for any tips you have, Seth

2

make sure you only are using rails 2.0.1 (clean up old rails library)

I'm using a different spec:

  adapter: sqlserver   database: mydb   username: username   password: pasword   host: thehosturl   mode: ADO   provider: SQLOLEDB

3

make sure you only are using rails 2.0.1 (clean up old rails library)

I'm using a different spec:

  adapter: sqlserver   database: mydb   username: username   password: pasword   host: thehosturl   mode: ADO   provider: SQLOLEDB

4

Don't use MS COM+ objects in linux, that is impossible :slight_smile: SQLOLEDB is COM+ and doesn't work under linux Use freeTDS and unixODBC to connect to sqlserver and sqlserver adapter for rails

Sorry if for late reply, if you already solved your problem maybe this would be helpful to somebody else.

Regards