Ruby on Rails Monday, January 31, 2011

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

--
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 rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

No comments:

Post a Comment