python - Error connecting to SQL Server from Ubuntu+PYODBC -
i found many similar question none of solutions worked me. seems pretty simple matter still can't find solution. i'm using headless ubuntu server connect sql server on windows server 2008 using python script using pyodbc. script runs on local windows machines, when try on ubuntu server error: error: ('im002', '[im002] [unixodbc][driver manager]data source name not found, , no default driver specified (0) (sqldriverconnect)') the connection string i'm using is: connectionstring='driver={dbserverdsn};server=10.23.11.10;database=market;uid=usr;pwd=pwd;tds_version=7.2;port=1433' any thoughts ? in advance edit : adding main files odbc.ini [dbserverdsn] driver = freetds server = 10.23.11.10 port = 1433 database=markets tds_version = 7.2 odbcinst.ini [freetds] description = v0.91 protocol v7.2 driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so freetds.conf [global] # tds protocol version, use: ...