In Progress

Connection from Rails app on Heroku to MS SQL DB on other server

We need help to setup a working database connection from a Ruby on Rails app running on [url removed, login to view] to a Microsoft SQL Server 2012 database running on a Windows Server 2008 R2 Enterprise 64-bit.

We have tried to setup the connection ourselves but get the error listed below.

The Rails source code is hosted on GitHub and you will get access to the repo so that you can commit necessary changes to the code.

> rails -v

Rails 3.2.8

> ruby --version

ruby [url removed, login to view]

Heroku URL

[url removed, login to view]


> heroku logs


2013-10-17T04:17:36.781011+00:00 app[web.1]: => Booting WEBrick

2013-10-17T04:17:36.781042+00:00 app[web.1]: => Rails 3.2.8 application starting in production on

2013-10-17T04:17:36.781060+00:00 app[web.1]: => Call with -d to detach

2013-10-17T04:17:36.781065+00:00 app[web.1]: => Ctrl-C to shutdown server

2013-10-17T04:17:36.781074+00:00 app[web.1]: Exiting

2013-10-17T04:17:36.781160+00:00 app[web.1]: from /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/[url removed, login to view]:in `resolve_string_connection'

2013-10-17T04:17:36.781094+00:00 app[web.1]: /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/[url removed, login to view]:in `resolve_hash_connection': database configuration does not specify adapter (ActiveRecord::AdapterNotSpecified)

2013-10-17T04:17:36.781168+00:00 app[web.1]: from /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/[url removed, login to view]:in `spec'

2013-10-17T04:17:36.781177+00:00 app[web.1]: from /app/vendor/bundle/ruby/1.9.1/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/[url removed, login to view]:in `establish_connection'


Skills: Database Administration, Ruby on Rails, SQL

See more: vendor database ms access, ruby on rails version, ruby on rails sql server, ruby on rails server, ruby on rails gems, ruby on rails database, ruby on rails app, ruby on rails 1.9 3, on spec application, need help ruby, ms access administration, microsoft access administration, help with ruby on rails, error ruby on rails, access vendor database, sql microsoft access, rails github, microsoft access sql, microsoft access 2013 help, heroku ruby on rails, github ruby on rails, database vendor, ruby on rails heroku, Sql Database administration, server 2012 administration

About the Employer:
( 0 reviews ) Copenhagen V, Denmark

Project ID: #5036078

Awarded to:


I'm interested. Should be like this post described: [url removed, login to view]

$250 USD in 3 days
(13 Reviews)

9 freelancers are bidding on average $188 for this job


Heroku by default support Postgres data server for free versions. Other DB connectivity can be made available via add on. MSSQL server pack is not supported by heroku rightnow. But I can give a try using heroku-buildp More

$155 USD in 3 days
(9 Reviews)

Hi Sir, I 'm a SQL Server DBA 10+ years of experience. Also I'm aVS developer, I can help you with this connection issue. Thanks in advance!

$155 USD in 2 days
(3 Reviews)

Hey, One of my latest projects is an Ruby on Rails application running on MSSQL, We use Heroku for staging and Azure/AWS for production (multi cloud deployment). I'm sure I can help fix your problem. Gabriel

$222 USD in 3 days
(1 Review)

Hello My name is Matthew Andrews have a look at my resume, please consider my bid. [url removed, login to view]

$210 USD in 1 day
(1 Review)

Hi, I have 5+ years of experience in Ruby on Rails and had good knowledge about web development. Mostly worked on ecommerce applications, content management system, organization performance evaluation system,job po More

$166 USD in 3 days
(1 Review)

Hi, I can solve this issue.. Do check my portfolio , i have been working in rails for my past two years.. and also recently i did the same task using heroku app.. i can fix this issue soon.. thanks, hari

$222 USD in 3 days
(0 Reviews)

Hello, I'm Ruby developer and have experience in heroku deployment. I want to try to fix this problem. Don't hesitate to message me if you have any questions. Thank you.

$155 USD in 3 days
(0 Reviews)

Hi, I can do this for you. The possible solutions may include simple solutions as indentation in the [url removed, login to view] file to chnging configuration of MSSql.. I was stuck with the same problem earlier. I can do this fo More

$155 USD in 3 days
(0 Reviews)