Not sure why it’s calling to MYSQL (not mssql), maybe you should check the Repo configuration for the adapter. It should be
config :my_app, MyApp.Repo,
adapter: MssqlEcto
(it seems to be MySql)
FYI, I had a similar use case (read only) and I’ve avoided using ecto (another dependency), and I just used raw sql queries from mssqlex. It was way simpler for this case. Maybe it’s a good idea also for you?
