Skip to content

Instantly share code, notes, and snippets.

@katsuyoshi
Created July 17, 2013 06:06
Show Gist options
  • Save katsuyoshi/6018022 to your computer and use it in GitHub Desktop.
Save katsuyoshi/6018022 to your computer and use it in GitHub Desktop.
connect to sqlserver by rails
# 参照:
# http://ameblo.jp/murajun1/entry-11266484358.html
$ brew install freetds
$ gem install tiny_tds
$ gem install activerecord-sqlserver-adapter
$ rails new sqlserver-test
$ cd sqlserver-test
# Windows設定
# set sa account.(set password)
# launch firewall control panel
# add SQL Server Windows NT - 64 bit which located c:¥Program Files¥Microsoft SQL Server¥MSSQL11.SQLEXPRESS¥MSSQL¥Binn¥sqlservr.exe
# 参照:
# p://awoni.net/fc/remote/
# http://www.kuron-zero.com/port/windows8a.php
# http://faq.buffalo.jp/app/answers/detail/a_id/792
# rubyで
# 参照
# http://d.hatena.ne.jp/htgc/20130310/1362863878
# brew install freeted
# brew install unixODBC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment