I’m trying to create an API that interfaces to a MS SQL database. My mix deps.get reports no errors or problems, but when I mix run --no-halt, I get a series of warnings about SQL and migrations (my app is a read-only app for an existing MS SQL database so I have no migrations). How do I deal with …

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 …

[image] matreyes: adapter: MssqlEcto My Repo is like this, but your idea would work, I’ll think about doing that. defmodule TwApi.Repo do use Ecto.Repo, otp_app: :tw_api, adapter: Ecto.Adapters.MssqlEcto ... ... end

But it’s still calling to the mysql adapter… have you checked your config files?

I’ve been checking EVERY file - not a MySQL anywhere!?!? It seems to be something that elixir is adding in ‘after the fact’…

Maybe as default, when no config was set… :man_shrugging:

Please check your mix.lock which version of ecto got pulled in. Perhaps we can use that information to narrow things down.

"ecto": {:hex, :ecto, "2.2.12", "ce7f619c1451daad0f59e8f01fd8e2584226171dc273e3346444446a13d93943", [:mix], [{:db_connection, "~> 1.1", [hex: :db_connection, repo: "hexpm", optional: true]}, {:decimal, "~> 1.2", [hex: :decimal, repo: "hexpm", optional: false]}, {:mariaex, "~> 0.8.0", [hex: :mariae…

Elixir Programming Language Forum

Mysql errors when using mssql

Questions & Help Questions

matreyes January 6, 2020, 11:10pm 6

Maybe as default, when no config was set…