I got this working finally. I decided to try the rails-sqlserver-2000-2005-adapter gem rather than the activerecord-odbc-adapter I was using before. I then had change the connection type in database.yml from: adapter:ODBC to: adapter:sqlserver mode:ODBC
This seems to have fixed the issue, and give me the added bonus of the sql output to the console, which I wasn't getting with the other adapter. thanks for all your input! -Ben -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---

