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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 On Dec 18 2007, 11:46 pm, elFonso <aadrias...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---