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?
Thankfully!
Ale