Installing SQL Server Adapter as Gem for Rails 2.0

Rails
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