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