These are chat archives for rails-sqlserver/activerecord-sqlserver-adapter

13th
Dec 2016
Jed Schneider
@jedschneider
Dec 13 2016 01:10
curious if anyone in the room uses Azure SQL Server from a Heroku app. We've been doing that for about a year and I believe I've detected a change in the way Heroku spins up the app, and it prevents me from using our current buildpack strategy for declaring the database settings. The current problem is that I am getting a TDS error which tells me /app/vendor/bundle/ruby/2.2.0/gems/tiny_tds-0.6.3.rc1/lib/tiny_tds/client.rb:74:inconnect': USE statement is not supported to switch between databases. Use a new connection to connect to a different database. (TinyTds::Error)`. I dont get this when running from a vm deploy of MSSQL and so I'm thinking that it must be that the azure: true flag is not getting set. But without writing my own database connection string that is parsed by the buildpack, I don't know another way to connect. Thoughts?
Jed Schneider
@jedschneider
Dec 13 2016 13:10
pushed this conversation into a github issue, so bowing out of this channel, thanks: rails-sqlserver/activerecord-sqlserver-adapter#497