Installing SQL Server Adapter as Gem for Rails 2.0

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

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

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

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