Ruby on Rails on Windows Azure with SQL Azure

re: Ruby on Rails on Windows Azure with SQL Azure

Aymeric — Wed, 13 Oct 2010 07:35:47 GMT

Why not host it on Heroku? Are there any benefits on Azure over Heroku?

re: Ruby on Rails on Windows Azure with SQL Azure

nick — Sat, 02 Oct 2010 22:29:26 GMT

Ameer, did you make the appropriate firewall settings on SQL Azure?

re: Ruby on Rails on Windows Azure with SQL Azure

k1hash — Fri, 17 Sep 2010 10:23:29 GMT

Hi,

It takes long time to include Ruby Folder into the solution and package file become to much huge.

Are there any way to solve these problems?

re: Ruby on Rails on Windows Azure with SQL Azure

Nick — Thu, 02 Sep 2010 08:29:54 GMT

Hi Hani,

Thanks for your comment. It is a while ago since I did this but I seem to recall that certain versions of ruby behaved diffferently when installing GEMS. I was using ruby 1.8 with active record 2.2.2 and the SQL Adapter 2.3.1. Have you read this article? www.ruby-forum.com/.../134660. I am quite busy at present but will try to take a look over the weekend.

Nick

re: Ruby on Rails on Windows Azure with SQL Azure

Ameer Deen — Wed, 01 Sep 2010 02:27:40 GMT

Hi there Nick,

I tried the above methods and received a "no such file to load -- odbc". I've instead tried with IronRuby. Using iron ruby to connect to a local instance works fine but does not work against SQL Azure. Any ideas? Here's my database.yml

development:

mode: ADONET

adapter: sqlserver

host: nrvk7uv6tl.database.windows.net

database: mydb

username: myuser

password: mypassword

Ameer Deen

re: Ruby on Rails on Windows Azure with SQL Azure

Hani Shaw — Mon, 30 Aug 2010 11:47:01 GMT

Hi there Nick,

This is a wonderful article and I'm trying to follow and get a rails app running against SQL Azure. I've got my rails app running against sqlite.

I'm running ruby 1.8.7 with the following gems installed:

gem install rails --version 2.3.8

gem install activerecord-sqlserver-adapter --version 2.3.8

Running gem install activerecord-sqlserver-adapter --source=http://gems.rubyonrails.org gave me an error:

ERROR: Could not find a valid gem 'activerecord-sqlserver-adapter' (>= 0) in any repository

Once rails and the sqlserver active record gem was installed, I updated my database.yml and started up my server but got the following error:

Please install the sqlserver adapter: `gem install activerecord-sqlserver-adapter` (no such file to load -- active_record/connection_adapters/sqlserver_adapter

Can you please help?

Hani