pyodbc and ubuntu (jaunty)

Mr. Eden has a great post on accessing mssql from linux.

I had to add one package (unixodbc-dev) to get things working so I ended up with the following:

sudo aptitude install unixodbc unixodbc-dev freetds-dev tdsodbc python-dev


Once this was done the usual “python setup.py install” no longer ended in tears. He also included instruction on editing the odbcinst.ini file.