Ozzie.eu

Love to code, although it bugs me.

Showing posts with label troubleshooting. Show all posts
Showing posts with label troubleshooting. Show all posts

Troubleshooting pymssql installation on Ubuntu


Installing pymssql on Ubuntu 13.10 was not an easy task. Trying to install directly from the .egg file gave an UCS2-UCS4 incompatibility error. So I installed it from source.

After installing the FreeTDS packages, the process was as follows:

  1. Get source from https://github.com/pymssql/pymssql
  2. Error: _mssql.c:8:22: fatal error: pyconfig.h: No such file or directory
  3. Install Python development libraries: sudo apt-get install python-dev
  4. Error: _mssql.c:314:22: fatal error: sqlfront.h: No such file or directory
  5. Install freeTDS development libraries: sudo apt-get install freetds-dev
  6. Install pymssql from the unzipped source directory: sudo python setup.py install
Success!