Conection Rails with Sql Server 2000

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

On Jan 31, 6:33 pm, Alessandra [email protected] wrote:

  adapter: sqlserver
  password:

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ć

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs