Daily Archives: November 25, 2015


Use MS SQL with pyodbc on debian

I am using pyodbc in a python script under linux (debian 8) to connect to a MS-SQL Database. Here is my configuration for the database access. I can’t remember exactly which packages from the packagemanger I’ve installed 🙁 but maybe I have choosen the following: freetds-bin, freetds-common, freetds-dev, odbcinst Configuration /etc/odbc.ini [mcc] Driver = FreeTDS Description = ODBC connection via FreeTDS Trace = No Servername = mcc Port = 1433 Database = mcc Charset = UTF-8 /etc/odbcinst.ini [FreeTDS] Description = TDS driver (Sybase/MS SQL) Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so CPTimeout = CPReuse = FileUsage = 1 /etc/freetds/freetds.conf [mcc] host = server.test.com port = 1433 tds […]