Skip to content

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

Install the Microsoft ODBC driver, then:

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

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.