2011-01-31 linux python mssql odbc pyodbc
Более свежая статья тут: Настраиваем pyodbc в linux ubuntu
Доступ через pyodbc, устанавливаем необходимые компоненты:
sudo aptitude install unixodbc unixodbc-dev freetds-dev tdsodbc python-dev
sudo easy_install pyodbc
[FreeTDS]
Description = TDS driver (Sybase/MS SQL)
Driver = /usr/lib/odbc/libtdsodbc.so
Setup = /usr/lib/odbc/libtdsS.so
CPTimeout =
CPReuse =
import pyodbc
conn = pyodbc.connect("DRIVER={FreeTDS};SERVER=__server_name__;\
UID=__username__;PWD=__password__;DATABASE=__database__")
crms = conn.cursor()
crms.execute('SELECT 1')
for line in crms:
print line
conn.close()