Awesome Open Source
Awesome Open Source


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

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
elixir (1,163
sql-server (77
hex (57
ecto (42
odbc (19

Find Open Source By Browsing 7,000 Topics Across 59 Categories