Closed

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

This project was awarded to aamaia for $250 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

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]

Error
> heroku logs
...
2013-10-17T04:17:[url removed, login to view]+00:00 app[web.1]: => Booting WEBrick
2013-10-17T04:17:[url removed, login to view]+00:00 app[web.1]: => Rails 3.2.8 application starting in production on http://0.0.0.0:27651
2013-10-17T04:17:[url removed, login to view]+00:00 app[web.1]: => Call with -d to detach
2013-10-17T04:17:[url removed, login to view]+00:00 app[web.1]: => Ctrl-C to shutdown server
2013-10-17T04:17:[url removed, login to view]+00:00 app[web.1]: Exiting
2013-10-17T04:17:[url removed, login to view]+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:[url removed, login to view]+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:[url removed, login to view]+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:[url removed, login to view]+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'
...

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online