Installing SQL Server Adapter as Gem for Rails 2.0

202 views
Skip to first unread message

Seth

unread,
Dec 13, 2007, 4:32:48 PM12/13/07
to Ruby on Rails: Talk
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

elFonso

unread,
Dec 18, 2007, 5:46:50 PM12/18/07
to Ruby on Rails: Talk
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

elFonso

unread,
Dec 18, 2007, 5:47:16 PM12/18/07
to Ruby on Rails: Talk
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


On Dec 13, 1:32 pm, Seth <sethl...@gmail.com> wrote:

miskovac

unread,
Jan 2, 2008, 6:15:45 PM1/2/08
to Ruby on Rails: Talk
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
Reply all
Reply to author
Forward
0 new messages