Forums » Ruby on Rails » is any one exist here?
is anyone exist here to help? or just created the forum for fun? frm last 9months der is not activity in this particular section.
'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:
adapter: sqlserver
mode: odbc
dsn: mydsn;
Server = my_server_name;
username: myuser

this is my database.yml

above config works fine for MS SQL 2005 SUCCESSFULLY. But i want to
work with MSSQL 2000. please provide some help.
@soorajb: thanks for rpyng.. i tried using the suggested gem. its not working. im getting the error saying RAKE ABORTED. THIS GEM SUPPORTS ONLY SQL SERVER 2005 AND LATER..

so kindly look into the matter..
the gem named active-record-sqlserver-adapter works fine with ms msqlserver 2005..

i want for sql server 2000