# MssqlexV3

[![Build Status](](
[![Coverage Status](](
[![Inline docs](](
[![ Version](](
[![ Downloads](](

Adapter to Microsoft SQL Server. Using `DBConnection` and `ODBC`.

It connects to [Ecto]( with [MssqlEcto](


This library was forked([Mssqlex]( and expanded in a hurried way.
It's not finished. Tests are passing, but docs are in mess. Use it with caution!

## Installation

MssqlexV3 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`).

MssqlexV3 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_v3` to your list of dependencies in `mix.exs`:

def deps do
  [{:mssqlex_v3, "~> 3.0.0"}]

## Testing

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.

You can create `.env` file and set all required environment variables
export MSSQL_UID=sa
export MSSQL_PWD='sa_5ecretpa$$'

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

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=$MSSQL_PWD' -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest

### Testing info

Maintenance DB - `master`