Install pyodbc: SqlServer

SqlServer - install pyodbc

This is included in Docker, but not for local installs. To install pyodbc (either global to your machine, or within a venv):

• Linux

apt install unixodbc-dev   # Linux only
pip install pyodbc

• Mac - using brew:

Install the Microsoft ODBC driver, then:

# may be required - brew install unixodbc      # Mac only
pip install pyodbc==5.1.0

• Windows - not resolved - this approach is not tested

Please see the examples on the testing for important considerations in specifying SQLAlchemy URIs.

 

Limitations - SqlServer Sort fields

Note Sql/Server may not sort on certain fields such as images or long text. This shows up, for example, in the Docker SqlServer sample database for Category. So, when testing these in Swagger, modify your Sort fields accordingly.