Setting up Rails with MS SQL


#1

Hello everyone. I am trying to get Rails working with MS SQL. I have
updated database.yml in my application, intalled the
activerecord-sqlserver-adapter gem as well as the deprecated gem. I have
also downloaded ADO.rb into the appropiate folder (Ruby
path\lib\site_ruby\1.8\dbd\ado) However, when I run “rake db:migrate” I
get the following error:

rake aborted!
Unable to load driver ‘ADO’ (underlying error: uninitialized constant
DBI::DBD::ADO)

(See full trace by running task with --trace)

Thanks to everyone!


#2

I am having exactly the same problem. I was able to create an ODBC
connection on the server and connect that way, but that’s not ideal.