Adapter to Microsoft SQL Server. Using DBConnection and ODBC.

ecto, elixir, hex, microsoft-sql-server, mssql-database, odbc, sql-server



Build Status Coverage Status Inline docs Ebert Version Downloads License

Adapter to Microsoft SQL Server. Using DBConnection and ODBC.

It connects to Ecto with MssqlEcto.


Mssqlex requires the Erlang ODBC application to be installed. This might require the installation of an additional package depending on how you have installed Erlang (e.g. on Ubuntu sudo apt-get install erlang-odbc).

Mssqlex depends on Microsoft's ODBC Driver for SQL Server. You can find installation instructions for Linux or other platforms on the official site.

This package is availabe in Hex, the package can be installed by adding mssqlex to your list of dependencies in mix.exs:

def deps do
  [{:mssqlex, "~> 1.1.0"}]


Tests require an instance of SQL Server to be running on localhost and a valid UID and password to be set in the MSSQL_UID and MSSQL_PWD environment variables, respectively.

The easiest way to get an instance running is to use the SQL Server Docker image:

export MSSQL_UID=sa
export MSSQL_PWD='ThePa$$word'
docker run -e 'ACCEPT_EULA=Y' -e SA_PASSWORD=$MSSQL_PWD -p 1433:1433 -d microsoft/mssql-server-linux