# Installing SQL Server Adapter as Gem for Rails 2.0

**URL:** <https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086>\
**Category:** Rails\
**Created:** [December 13, 2007, 10:33pm UTC](https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086 "2007-12-13T22:33:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![seth](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f14d63/32.png) [@seth](https://www.ruby-forum.com/u/seth)\
**Post date:** [December 13, 2007, 10:33pm UTC](https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086/1 "2007-12-13T22:33:12Z")

</div>

Hello,

I just installed the SQL Server Adapter Gem from [gems.rubyonrails.org](http://gems.rubyonrails.org)  
for my new Rails 2.0 project:

gem install activerecord-sqlserver-adapter --source=http://  
[gems.rubyonrails.org](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

---

<div class="post-metadata">

**Author:** ![seth](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f14d63/32.png) [@seth](https://www.ruby-forum.com/u/seth)\
**Post date:** [December 18, 2007, 11:47pm UTC](https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086/2 "2007-12-18T23:47:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![seth](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f14d63/32.png) [@seth](https://www.ruby-forum.com/u/seth)\
**Post date:** [December 18, 2007, 11:47pm UTC](https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086/3 "2007-12-18T23:47:45Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![seth](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/f14d63/32.png) [@seth](https://www.ruby-forum.com/u/seth)\
**Post date:** [January 3, 2008, 12:16am UTC](https://www.ruby-forum.com/t/installing-sql-server-adapter-as-gem-for-rails-2-0/123086/4 "2008-01-03T00:16:18Z")

</div>

Don’t use MS COM+ objects in linux, that is impossible 🙂 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