Ruby on Rails

On Jan 31, 6:33 pm, Alessandra <acard...@fcm.unicamp.br> 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 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.