Connection from Rails app on Heroku to MS SQL DB on other server
$30-250 USD
货到付款
We need help to setup a working database connection from a Ruby on Rails app running on [login to view URL] 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 1.9.3p194
Heroku URL
[login to view URL]
Error
> 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 http://0.0.0.0:27651
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/[login to view URL]: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/[login to view URL]: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/[login to view URL]: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/[login to view URL]:in `establish_connection'
...
项目ID: #5036078
关于项目
授予:
有8名威客正在参与此工作的竞标,均价$192/小时
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 更多
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!
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
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