On Jan 31, 6:33 pm, Alessandra <[email protected]> wrote: > Hello everybody, > > I'm trying to use Ruby on Rails accessing a pre-existing database on > SQL Server 2000. > After some research I found that it should use the gem activerecord- > sqlserver-adapter. Create a connection via ODBC to the > desired base, and creating a database user for access it. We also > configured the database.yml in the following ways: > > development: > adapter: sqlserver > mode: odbc > dsn: Driver = {SQL Server}; Server = myserver; Database = > minha_base; Trusted_Connection = yes; > > development: > adapter: sqlserver > dsn: my_dsn > mode: odbc > database: my_base > username: myuser > password: > > I've tried tried using the following versions, but none worked: > Ruby 1.9.2, Rails 3.0.9, activerecord-sqlserver-adapter 3.0.9 > (descrobi after which it was to sqlserver 2005 and 2008) > Ruby 1.9.2, Rails 3.0.9, activerecord-sqlserver-adapter 2.2.18 > (version for Sql 2000.2005, 2008) > Ruby 1.8.6, Rails 2.3.5, activerecord-sqlserver-adapter 2.2.18 > Ruby 1.8.7, Rails 2.3.5, activerecord-sqlserver-adapter 2.2.18 > Ruby 1.8.7, Rails 2.3.5, activerecord-sqlserver-adapter 2.3.14 > (version for Sql 2000.2005, 2008) > Ruby 1.8.7, Rails 2.0.2, activerecord-sqlserver-adapter 2.2.18 > > Could someone help me?
You have to install ruby-odbc (http://www.ch-werner.de/rubyodbc/) too. Regards, Boško Ivanišević -- 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.
