tag:blogger.com,1999:blog-4172981932098931033.post6010467444177960395..comments2010-05-05T09:27:44.828-07:00saltybananahttp://www.blogger.com/profile/02266260856342765794noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4172981932098931033.post-35025895992366048772010-05-05T09:27:44.816-07:002010-05-05T09:27:44.816-07:00This is the new definitive way to setup Rails for Windows / sql server<br /><br />http://sites.martycullen.com/home/home/marty-4/ruby-setupYodaTravishttp://www.blogger.com/profile/07804698603520528308noreply@blogger.comtag:blogger.com,1999:blog-4172981932098931033.post-82271396208619806032009-03-18T19:01:00.000-07:002009-03-18T19:01:00.000-07:00I know this article is old news but I was able to install activerecord-sqlserver-adapter after running:<BR/><BR/>gem sources -a http://gems.rubyonrails.orgMatt Whitehttp://www.blogger.com/profile/18397683832207560828noreply@blogger.comtag:blogger.com,1999:blog-4172981932098931033.post-13383267971440113432008-06-05T13:32:00.000-07:002008-06-05T13:32:00.000-07:00btw, I found this <A HREF="http://piao-tech.blogspot.com/2008/02/using-activerecord-with-microsoft-sql.html" REL="nofollow">site</A> helpful. It explains the difference between the ADO and ODBC versions of the ActiveRecord/Ruby connection and also talks about the differences that exist between getting SQLServer access in a Windows versus Linux environmentTravishttp://www.blogger.com/profile/07804698603520528308noreply@blogger.comtag:blogger.com,1999:blog-4172981932098931033.post-80266304405026557942008-06-05T11:00:00.000-07:002008-06-05T11:00:00.000-07:00I am experiencing this problem right now. I have a greenfield project starting in the next week or so and I'm researching the best tools for the job. I know Ruby and Active Record would make this project go much smoother (my alternatives are c# or java) but if I can't even get Active Record working with our MS SQL backend then I'll be forced down another path. I would encourage anyone who has gotten Ruby/ActiveRecord/SQLServer working lately in a windows environment (This is for work and we are a windows shop.) to post examples here. Thanks in advance.Travishttp://www.blogger.com/profile/07804698603520528308noreply@blogger.com