Have you tried using this instead? http://github.com/rails-sqlserver/2000-2005-adapter/tree/master
We don't use the activerecord-odbc adapter for our apps. We also install ruby-odbc and ruby dbi from source rather than from gems, but I hear that gems work fine $ gem install dbi --version 0.4.0 $ gem install dbd-odbc --version 0.2.4 I can't say if this works on 2008 because I've been too busy to test it, so if it doesn't, I apologize. However, I've monkeyed with the sqlserver adapters in the past and patching it should be trivial. Let us know how it goes! On Wed, Jan 7, 2009 at 11:01 AM, Ben <[email protected]> wrote: > > Can any one else please help me to confirm that migrations are broken > against SQL Server 2008? I'm running Rails 2.2.2 and activerecord-odbc- > adapter 2.0 gem. I've created a system DSN to my test database using > an authenticated connection. > > I've created a single migration to make a table with a few columns in > it and when you run the 'rake db:migrate' the first time, everything > works correctly. However, if you run it again (which shouldn't change > anything) I get the following error > > 'rake aborted! > S0001 (2714) [Microsoft][ODBC SQL Server Driver][SQL Server]There is > already an object named 'schema_migrations' in the database. > > I think the 'activerecord-odbc-adapter' gem isn't compatible with SQL > Server 2008 as I've tested the same migration against SQL Server 2000 > and that seems to work fine. Does anyone else know of another gem/ > plugin that allows authenticated connections to SQL Server 2008 that > works properly? > > Thanks :) > > > --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
